I have a table now oracle, there are hundreds of millions of data, you need to the export good made test data in a text format, the problem is how to export the come on! Newcomer, belt, thank you very much

CodePudding user response:

Sqlldr2, can try this

CodePudding user response:

I didn't contact with oracle, trouble can say detailed point? A: what happened?

CodePudding user response:

refer to the second floor qq_40090700 response:

I didn't contact with oracle, trouble can say the detailed point? A: what happened?

Baidu once had, this tool bring help, use more convenient, also
I think you should struggle is derived when the delimiter, because lead into text, separator choose inadvertent, data may be violated,

CodePudding user response:

reference 1st floor wmxcn2000 response:

sqlldr2, can try this

reference 1st floor wmxcn2000 response:

sqlldr2, can try this

Is written sqluldr2 ali a the elder brothers, usage under the reference, the key you want to download sqluldr2

CodePudding user response:

Oracle data export tool sqluldr2 data can be as CSV, TXT file formats, such as export, is suitable for bulk data export, export very fast,
Export, you can also use Oracle SQL Loader tool to guide data back to the database, the hope that useful to you ~

CodePudding user response:

Don't contact with great spirit upstairs said sqlldr2, baidu just now, as oracle's own formatting export, goal is to SQLLDR import,



We usually export data, and other companies do interface, generate TXT or CSV spool is used to derive the, can custom fields, name, the delimiter,

CodePudding user response:

refer to 6th floor youlingsxcn response:

don't contact with great spirit upstairs said sqlldr2, baidu just now, as oracle's own formatting export, goal is to SQLLDR import,



We usually export data, and other companies do interface, generate TXT or CSV spool is used to derive the, can custom fields, name, the delimiter,

~ sqlldr2 can completely meet your demand

CodePudding user response:

We just contact with Oracle data import and export, also has to borrow tools (kettle), also import and export of using PL/SQL function, can use SQLLODADER also, speed faster, but not very friendly interface, baidu has a lot of tutorials, the hope can help you,

CodePudding user response:

Sqlldr2 export speed faster than Oracle itself own export many, very practical tool

CodePudding user response:

Upstairs is write wrong name, it is the sqluldr2 ha, search