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
- 32839 Views
- I also Faced
- E-Mail Answers
Answer Posted / maumita bandyopadhyay
We can use External table to extract data from data base
to .csv file. External table of TYPE ORACLE_DATAPUMP will
do.
Syntax is:
CREATE TABLE <ext_table_name>
ORGANISED EXTERNALLY
(
TYPE ORACLE_DATAPUMP
DEFAULT DIRECTORY <directory_name>
LOCATION <filename.dat>
)
AS SELECT * FROM <internal_table_name>
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the basic structure of an sql?
Why having clause is used in sql?
What are the advantages of indexing?
What is clause?
How to use distinct and count in sql query? Explain
What is nosql db?
Is record in oracle pl sql?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
What is pl/sql language case sensitive?
Why we use sql profiler?
What are sql procedures?
How do I run a script in sql developer?
Is sql a programming?
What will you get by the cursor attribute sql%rowcount?
Where the sql database files are stored?
