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
- 34272 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 are different categories of sql commands?
What are the methods of filing?
Does truncate release storage space?
What are basic techniques of indexing?
What are literals in sql server?
What is cold data?
What are the two types of exceptions.
what is table? : Sql dba
What are the different sql languages?
Which table is left in left join?
How to get unique records from a table?
How can triggers be used for the table auditing?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
what is the functionality of the function htmlentities? : Sql dba
Why is a primary key important?
