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 table? : Sql dba
How many parts of a pl sql block are optional?
How to execute a stored procedure?
What do you mean by query optimization?
Is id a reserved word in sql?
Define the select into statement.
how can we optimize or increase the speed of a mysql select query? : Sql dba
When do we use triggers?
What is memory optimized?
What type of database is sql?
How does rowid help in running a query faster?
What is normalization in sql?
What is the purpose of a sql?
What is sql character function?
Which sorts rows in sql?