已连接到 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
解决方案 »
- 菜鸟初始jdbc的问题
- oracle 11g 的有关问题 (有点繁琐 希望各位大侠帮忙 多给分)
- Websphere连不上oracle数据库,跪求高人指点,谢谢。错误日志如下:
- 请教高手 ,Oracle 中自定义的确定性函数执行效率的问题
- 最近觉得静不下心来
- 登录Oracle企业管理器(Enterprise Manager Console)怎么不用密码,难道是bug?
- 为什么用存储过程查询要5秒钟时间
- 在WINDOWS下安装ORACLE的客户端,如何安装!数据库在服务器上
- oracle -> informix
- 问个弱智的问题!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;