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 union and union all keyword in sql and what are their differences?
What is the basic form of sql query?
What do you mean by stored procedures?
How can we store rows in PL/SQL using array?
What is the best free sql database?
What are the packages in pl sql?
Explain the purpose of %type and %rowtype data types?
What is dense_rank?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
What is scalar data type in pl sql?
What is pessimistic concurrency control? : Transact sql
Can we use join in subquery?
Is clustered index a primary key?
what are date and time data types in mysql? : Sql dba
Is pl sql useful?