[转载]ORACLE数据库开发经验

zaokaichen

不错

xiaodong_1567

不错的东东
谢谢分享

vhdl74160

刚刚接触ORACLE，从LZ那学了不少呢

pingpong_zhao

学习很好

ccc96317

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
Cocuments and Settingsdennyliu>sqlplus sys as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Fri May 23 17:55:24 2008
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Enter password:
Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
SQL> create tablespace test_space datafile 'CraclexeoradataXE        est_space.db
f' size 1000 autoextend off;
create tablespace test_space datafile 'CraclexeoradataXE        est_space.dbf' si
ze 1000 autoextend off
*
ERROR at line 1:
ORA-03214: File Size specified is smaller than minimum required

SQL>  create tablespace test_space datafile 'CraclexeoradataXE        est_space.d
bf' size 10k autoextend off;
create tablespace test_space datafile 'CraclexeoradataXE        est_space.dbf' s
ize 10k autoextend off
*
ERROR at line 1:
ORA-03214: File Size specified is smaller than minimum required

SQL>  create tablespace test_space datafile 'CraclexeoradataXE        est_space.d
bf' size 100k autoextend off;
Tablespace created.
SQL> create table test1 (name varchar2(4000)) tablespace test_space;
Table created.
SQL> insert into test1 select object_name from dba_objects;
insert into test1 select object_name from dba_objects
            *
ERROR at line 1:
ORA-01653: unable to extend table SYS.TEST1 by 8 in tablespace TEST_SPACE

SQL> insert into test1 select object_name from dba_objects where rownum <1000;
999 rows created.
SQL> commit;
Commit complete.
SQL> insert into test1 select object_name from dba_objects where rownum <1000;
insert into test1 select object_name from dba_objects where rownum <1000
            *
ERROR at line 1:
ORA-01653: unable to extend table SYS.TEST1 by 8 in tablespace TEST_SPACE

SQL> delete from test1;
999 rows deleted.
SQL> commit;
Commit complete.
SQL> insert into test1 select object_name from dba_objects where rownum <1000;
999 rows created.
SQL> commit;
Commit complete.
SQL> drop tablespace test1 cascade;
drop tablespace test1 cascade
                      *
ERROR at line 1:
ORA-02173: invalid option for DROP TABLESPACE

SQL>  drop tablespace test1;
drop tablespace test1
*
ERROR at line 1:
ORA-00959: tablespace 'TEST1' does not exist

SQL> drop tablespace test_space;
drop tablespace test_space
*
ERROR at line 1:
ORA-01549: tablespace not empty, use INCLUDING CONTENTS option

SQL>  drop tablespace test_space including contents;
Tablespace dropped.

[ 本帖最后由 ccc96317 于 2008-5-23 18:08 编辑 ]

olive

不是吧？8年前的东西翻出来说好？

xiaodong_1567

数据库系统很多理论也多年不变了吧

jvkojvko

ITPUB有你们才精彩！

ccc96317

里面有个地方很明显的有错

xiaodong_1567

原帖由 ccc96317 于 2008-5-26 10:18 发表
里面有个地方很明显的有错

没看出来