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
- 34398 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 sql in java?
What is the use of <> sql?
Can you have a foreign key without a primary key?
How do I create a memory optimized filegroup?
Is delete faster than truncate?
State few characteristics of pl/sql?
What trigger means?
Explain what is a column in a table?
Explain ttitle and btitle.
What are the different types of tables in sql?
What is the difference between sum and count in sql?
What is the starting oracle error number? What is meant by forward declaration in functions?
what is the command used to fetch first 5 characters of the string? : Sql dba
Is mariadb a nosql database?
What is a null value?
