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
- 34046 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 %rowtype in pl sql?
How do you copy a table in sql?
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
how to calculate expressions with sql statements? : Sql dba
What is an escape character in sql?
What is the usage of distinct keyword?
How do you explain an index number?
Why use triggers in sql?
what is the difference between nested subquery and correlated subquery?
How do you declare a user-defined exception?
What is sql profiling in oracle?
What is your daily office routine?
What is the difference between in and between in sql?
how can we repair a mysql table? : Sql dba
what is timestamp in mysql? : Sql dba
