Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 34645 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
how to use like conditions? : Sql dba
Which is better trigger or stored procedure?
Which is faster count (*) or count 1?
What is a trigger word?
Explain the difference between 'between' & 'and' operators in sql
What does rownum mean in sql?
What is basic structure of pl sql?
what is the difference between truncate and drop statements? : Sql dba
Is it possible to create the following trigger: before or after update trigger for each row?
What are the different types of constraints?
How do sql databases work?
What is java sql connection?
What are %type and %rowtype for?
what are numeric data types? : Sql dba
how to dump a table to a file with 'mysqldump'? : Sql dba
