How to grade the database must export data in the table as TEXT file? In addition to the SPOOL and UTL_FILE package, many thanks!

CodePudding user response:

SPOOL export massive feel is inappropriate, the file will be very big, because he needs the length of the fixed line, if set the length of the short more than the characters will be removed, a long will waste resource file,
Use UTL_FILE normal point, other ways to estimate to use other languages or the third party tools are derived

CodePudding user response:

Shell script redirection, should also can

CodePudding user response:

What is the purpose of export to?
Can export to open also pretty hard

CodePudding user response:

Use expdp, the quickly;

CodePudding user response:

Sqluldr2 feasible

CodePudding user response:

Using exp export table space (I export 1.5 G)
Exp user/password @ server file=filefullpathname
The user for a user name password for the password server for instance name

As follows:



If the following message said export success

CodePudding user response:

If want to export the data in a table, can first write the select query SQL statement, and then export the DMP, if so, need to use par bag!

CodePudding user response:

Still can use sqluldr2, can use plsqlDev, toad tools such as auxiliary export,
Guide into TXT, open is a problem, it will be very card, and less intuitive analysis of data from the inside,
What is more specific requirements?

CodePudding user response:

Sqluldr2 is positive solutions

CodePudding user response:

1, check the Linux version
[attachment: sqluldr.zip]

The cat/proc/version
The following results
The Linux version 2.6.32-358. The el6. X86_64 ([email protected]) (GCC version 4.4.7 20120313 (Red Hat 4.4.7-3) (GCC)) # 1 SMP Tue Jan 29 11:47:41 EST 2013
You can see is 64

. 2, put the bag under this folder sqluldr2_linux64_10204 bin kao to/opt/app/oracle/product/11.2.0/db_1/bin (the corresponding file kao corresponding version)
Cp sqluldr2_linux64_10204. Bin/opt/app/oracle/product/11.2.0/db_1/bin/sqluldr2 bin

3, configuration. The following files to add the following variables
Vi. The following
Export LD_LIBRARY_PATH=$ORACLE_HOME/bin: $ORACLE_HOME/lib/lib:/usr/lib.

4, give sqluldr2. Bin file to add execute permissions
Chmod 775/opt/app/oracle/product/11.2.0/db_1/bin/sqluldr2 bin

5, in the/opt/app/oracle/product/11.2.0/db_1/bin/create get_tables. SQL file
Touch/opt/app/oracle/product/11.2.0/db_1/bin/get_tables. SQL

6, will need to execute the SQL statement in the get_tables. SQL

7, the implementation of export, generate testexport. CSV file
Sqluldr2. Bin USER=SQL username/password @ DB name=get_tables. SQL charset=ZHS16GBK head=yes text=CSV FILE=/opt/app/oracle/product/11.2.0/db_1/bin/testexport_2. TXT

Eight, to excel conversion