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
What is query execution plan in sql?
Why truncate is faster than delete?
Explain about various levels of constraint.
What are some emotional triggers?
What is a delimiter in sas?
What is a relationship and what are they?
What are operators available in sql?
Is primary key a clustered index?
What is the function that is used to transfer a pl/sql table log to a database table?
How many types of triggers are there in pl sql?
What is a join query?
How do I remove sql plus from windows 10?
what is a tablespace? : Sql dba
Explain foreign key in sql?
Are left and right joins the same?