已连接到 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
已连接为 SYS
SQL> host dir c: Volume in drive C has no label
Volume Serial Number is DC86-CFD4
Directory of C:\AUTOEXEC BAT 0 03-01-03 23:10
CONFIG SYS 0 03-01-03 23:10
CREATE~1 SQL 91 06-02-08 22:21
DATABA~1 ORA 5251072 06-02-09 21:44
DATABA~2 ORA 5251072 06-02-09 21:54
DOCUME~1 <DIR> 03-01-03 22:59
DOWNLO~1 <DIR> 05-11-20 16:40
DROPTA~1 SQL 242 06-02-08 22:23
DROPTA~1 ~SQ 242 06-02-08 22:23
INETPUB <DIR> 05-11-20 16:59
JCB_GJ <DIR> 05-12-13 13:39
PROGRA~1 <DIR> 03-01-03 23:01
RAVBIN <DIR> 05-10-02 13:44
TEMP <DIR> 06-01-15 16:22
TOOLS <DIR> 04-10-18 10:37
USAGET~1 TXT 16 05-11-24 10:28
WINDOWS <DIR> 03-01-03 22:53
~DTLOG TXT 315 06-02-07 10:03
18 file(s) 10503050 bytes
869565952 bytes freeSQL> ed
SQL> /PL/SQL 过程成功完成SQL> host dir c: Volume in drive C has no label
Volume Serial Number is DC86-CFD4
Directory of C:\AUTOEXEC BAT 0 03-01-03 23:10
CONFIG SYS 0 03-01-03 23:10
CREATE~1 SQL 91 06-02-08 22:21
DATABA~1 ORA 5251072 06-02-09 21:44
DATABA~2 ORA 5251072 06-02-09 21:56
DOCUME~1 <DIR> 03-01-03 22:59
DOWNLO~1 <DIR> 05-11-20 16:40
DROPTA~1 SQL 242 06-02-08 22:23
DROPTA~1 ~SQ 242 06-02-08 22:23
DTEST ORA 5251072 06-02-09 22:02 //
INETPUB <DIR> 05-11-20 16:59
JCB_GJ <DIR> 05-12-13 13:39
PROGRA~1 <DIR> 03-01-03 23:01
RAVBIN <DIR> 05-10-02 13:44
TEMP <DIR> 06-01-15 16:22
TOOLS <DIR> 04-10-18 10:37
USAGET~1 TXT 16 05-11-24 10:28
WINDOWS <DIR> 03-01-03 22:53
~DTLOG TXT 315 06-02-07 10:03
19 file(s) 15754122 bytes
868265472 bytes free
SQL> SELECT * FROM user_tablespaces where upper(tablespace_name) = 'DATABASE_TEST';TABLESPACE_NAME BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FORCE_LOGGING EXTENT_MANAGEMENT ALLOCATION_TYPE SEGMENT_SPACE_MANAGEMENT DEF_TAB_COMPRESSION RETENTION BIGFILE
------------------------------ ---------- -------------- ----------- ----------- ----------- ------------ ---------- --------- --------- --------- ------------- ----------------- --------------- ------------------------ ------------------- ----------- -------
DATABASE_TEST 8192 65536 1 2147483645 65536 ONLINE PERMANENT LOGGING NO LOCAL SYSTEM AUTO DISABLED NOT APPLY NO
已连接为 SYS
SQL> host dir c: Volume in drive C has no label
Volume Serial Number is DC86-CFD4
Directory of C:\AUTOEXEC BAT 0 03-01-03 23:10
CONFIG SYS 0 03-01-03 23:10
CREATE~1 SQL 91 06-02-08 22:21
DATABA~1 ORA 5251072 06-02-09 21:44
DATABA~2 ORA 5251072 06-02-09 21:54
DOCUME~1 <DIR> 03-01-03 22:59
DOWNLO~1 <DIR> 05-11-20 16:40
DROPTA~1 SQL 242 06-02-08 22:23
DROPTA~1 ~SQ 242 06-02-08 22:23
INETPUB <DIR> 05-11-20 16:59
JCB_GJ <DIR> 05-12-13 13:39
PROGRA~1 <DIR> 03-01-03 23:01
RAVBIN <DIR> 05-10-02 13:44
TEMP <DIR> 06-01-15 16:22
TOOLS <DIR> 04-10-18 10:37
USAGET~1 TXT 16 05-11-24 10:28
WINDOWS <DIR> 03-01-03 22:53
~DTLOG TXT 315 06-02-07 10:03
18 file(s) 10503050 bytes
869565952 bytes freeSQL> ed
SQL> /PL/SQL 过程成功完成SQL> host dir c: Volume in drive C has no label
Volume Serial Number is DC86-CFD4
Directory of C:\AUTOEXEC BAT 0 03-01-03 23:10
CONFIG SYS 0 03-01-03 23:10
CREATE~1 SQL 91 06-02-08 22:21
DATABA~1 ORA 5251072 06-02-09 21:44
DATABA~2 ORA 5251072 06-02-09 21:56
DOCUME~1 <DIR> 03-01-03 22:59
DOWNLO~1 <DIR> 05-11-20 16:40
DROPTA~1 SQL 242 06-02-08 22:23
DROPTA~1 ~SQ 242 06-02-08 22:23
DTEST ORA 5251072 06-02-09 22:02 //
INETPUB <DIR> 05-11-20 16:59
JCB_GJ <DIR> 05-12-13 13:39
PROGRA~1 <DIR> 03-01-03 23:01
RAVBIN <DIR> 05-10-02 13:44
TEMP <DIR> 06-01-15 16:22
TOOLS <DIR> 04-10-18 10:37
USAGET~1 TXT 16 05-11-24 10:28
WINDOWS <DIR> 03-01-03 22:53
~DTLOG TXT 315 06-02-07 10:03
19 file(s) 15754122 bytes
868265472 bytes free
SQL> SELECT * FROM user_tablespaces where upper(tablespace_name) = 'DATABASE_TEST';TABLESPACE_NAME BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FORCE_LOGGING EXTENT_MANAGEMENT ALLOCATION_TYPE SEGMENT_SPACE_MANAGEMENT DEF_TAB_COMPRESSION RETENTION BIGFILE
------------------------------ ---------- -------------- ----------- ----------- ----------- ------------ ---------- --------- --------- --------- ------------- ----------------- --------------- ------------------------ ------------------- ----------- -------
DATABASE_TEST 8192 65536 1 2147483645 65536 ONLINE PERMANENT LOGGING NO LOCAL SYSTEM AUTO DISABLED NOT APPLY NO
解决方案 »
- 刚建的用户以sysdba登录,可结果用户却为sys,为何?
- oracle8.17 怎样做备份向SQL SERVER 那样按一段的时间备份数据??急急!!!
- 写PRO*C都用什么工具啊 除oracle自带的!
- 求查询语句
- 如何在企业管理器中查看某个表中的数据?
- 怎样打开以前的数据库?
- OracleOraHome90TNSListener无法启动,重新配置时报"有其它程序占用资源,要先解决冲突",急啊!
- help!--高手们请救!oracle 9i 安装问题
- 请问在一个已经有10000多条记录的表里可不可以再增加或删除一个字段?修改一个字段的属性?要注意些什么?
- 安装oracle的安装文件的名字是什么?
- 40个人上机学 Oracle,上机环境应该怎么搭?
- 字符和时间函数问题
declare
TableCount number;
begin
select count(tablespace_name) into TableCount from user_tablespaces where upper(tablespace_name) = 'DATABASE_TEST';
if TableCount > 0 then
execute immediate 'drop tablespace DATABASE_TEST including contents AND DATAFILES';
end if;execute immediate 'CREATE TABLESPACE DATABASE_TEST LOGGING
DATAFILE ''C:\DTest.ora'' SIZE 5M AUTOEXTEND
ON MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE
MANAGEMENT AUTO' ;
end;