This article must be seen. Tomorrow, look at it, it's too tired today! How to use SQL * LoADER? Dragon2> SQLLDR Userid = C / C Control = lc2.ctl log = lc2.log bad = lc2.bad sql * loader: Release 9.2.0.1.0 - Production on Wed Jun 4 18:03:53 2003 CopyRight (C) 1982 , 2002, Oracle Corporation. Commit Point Reached - Logical Record Count 50 Dragon2> Where lc2.ctl content is: # -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------- Load DataInfile * Replaceinto Table Lc2fields Terminated by "," (LCSH, LCZT, LCRQ, LCSJ, LCGH) Begindata673969, 1,20010205, 174948,0000673969, 3,20010205,174709,0000 ... # ----------------------------------- --------- [06.05]: How do you know which Oracle options installed? Col Parameter for A35 Col Value for A35 SELECT * FROM V $ OPTION; [06.04]: How to increase the size of the table space? 1. Increase the size of the data file in the table space: ALTER DATABASE DATAFILE 'FileName' Resize NN M; 2, add a new data file to the table space: ALTER TABLESPACE TABLESPACENAME Add DataFile 'filename' size nn m; if you don't use Omf FILENAME needs to include the detailed path. [06.03]: How to create a holiday table similar? CREATE TABLE NEW_TABLE_NAME AS SELECT * FROM OLD_TABLE_NAME WHERE 1 = 2; [06.02]: 9i EXP BLOB ORA-01555 Error? ORA-01555: Snapshot Too Old: Rollback Segment Number with name "" TOO SMALL errors is the 9i blob bug. In general, Exp ORA-01555 can be solved by way of the following method: 1) Increase all rollback segments and do not allow automatic shrinkage (because we can't control which return segment that Expively uses EXP); 2) ExpiStent = n Only guarantees that a table data is the same time) and Direct = Y parameters; 3) Making exp; 4) When the database task is minimized; 4) For the extra large table, the Query clause can be brought to EXP.
