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.
- 8 Answers
- 32834 Views
- I also Faced
- E-Mail Answers
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
Enlist the advantages of sql.
What are the usages of sql?
Is sql better than excel?
what is 'mysqld'? : Sql dba
what is data manipulation language? : Sql dba
What is the usage of when clause in trigger?
What is a sql instance vs database?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
Is and as keyword in pl sql?
What is the life of an sql statement?
explain advantages of innodb over myisam. : Sql dba
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
Enlist some predefined exceptions?
What is serial sql?
What is rowid in sql?
