信息来源: it168
1. 如何创建带有CLOB类型字段的表?
CREATETABLE TEST2 (AAA CLOB);
INSERTINTO TEST2 VALUES('CCBZZPCCBZZP');
SELECT*FROM TEST2;
SELECT*FROM TEST2 WHERE DBMS_LOB.INSTR(TEST2.AAA,'B',1,1)>0;
ALTERTABLE TEST2 MOVE TABLESPACE USERS;
EXPUSER/PASSWORD FILE=A.DMP TABLES=(TEST2);
IMP USER/PASSWORD FILE=A.DMP FULL=Y;
7. 从哪个版本开始支持CLOB,BLOB等大字段?
以上测试环境为ORACLE92
SQL*Plus: Release 9.2.0.1.0 - Production on 星期四 9月 4 12:02:00 2003
Copyright ? 1982, 2002, Oracle Corporation. All rights reserved.
联机到:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
SQL>DROPTABLE TEST2;
DROPTABLE TEST2
*
ERROR 在行 1:
ORA-00942: 表格或视观表不存在
SQL>CREATETABLE TEST2 (AAA CLOB);
已建立表格.
SQL>INSERTINTO TEST2 VALUES('CCBZZPCCBZZP');
已建立 1 个数据列.
SQL>SELECT*FROM TEST2;
AAA
--------------------------------------------------------------------------------
CCBZZPCCBZZP
SQL>SELECT*FROM TEST2 WHERE DBMS_LOB.INSTR(TEST2.AAA,'B',1,1)>0;
AAA
--------------------------------------------------------------------------------
CCBZZPCCBZZP
SQL>ALTERTABLE TEST2 MOVE TABLESPACE USERS;
已更改表格.
SQL>
d:>exp test/test file=a.dmp tables=(test2)
......
Export done in ZHT16BIG5 charactersetand ZHT16BIG5 NCHARcharacterset
About to export specified tables via Conventional Path ...
. . exporting table TEST2 0 rows exported
Export terminated successfully without warnings.
SQL>droptable test2;
已删除表格.
d:> imp test/test file=a.dmp tables=(test2);
......
import done in ZHT16BIG5 charactersetand ZHT16BIG5 NCHARcharacterset
. importing TEST's objects into TEST
. . importing table "TEST2" 0 rows imported
Import terminated successfully without warnings.
