How to export the table data (this table having 18 million
records) to .csv file. Please tell me is there any faster
way to export the data.
Answer Posted / vellai
Hi,
In oracle,We have SQL loader utility tool. You can use that
utility with out creating index and referencial constraint.
thereafter you can see 18 million records are loaded within
a hour into database.
Thank you
Vellai
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Is sql better than access?
What is query execution plan in sql?
What is sql used for?
What is sql injection vulnerability?
what is offset-fetch filter in tsql? : Transact sql
Can we enter data in a table in design view?
What is left inner join in sql?
what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
What are the methods of filing?
What is the best partition size for windows 10?
What is normalization sql?
Mention what does plv msg allows you to do?
Is sql a backend?