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
- 34367 Views
- I also Faced
- E-Mail Answers
Answer Posted / kiran penujuri
We have one very good oracle utility called EXPORT
Exporting of ORACLE database objects is controlled by
parameters.
To get familiar with EXPORT parameters type:
exp help=y
You will get a short description and the default settings
will be shown.
The EXPORT utility may be used in three ways:
Interactive dialogue
Simply type exp. You will be prompted for your ORACLE
userid, password. All other prompts answer by pressing the
return key. This is the easiest way to export all data you
stored in the ORALE database. You may assign other values
than the defaults to the parameters but in most cases it is
unnecessary.
Controlled through bypassed parameters
You may bypass parameters when you export data from the
database. Type:
exp <userid/password>
<parameter>=<value>,<parameter>=<value>,...
Example of exporting scott's tables EMP and DEPT to file
empdept.expdat and storing all messages to file empdept.log:
exp scott/tiger file=empdept.expdat tables=(EMP,DEPT)
log=empdept.log
Parameterfile controlled
Instead of typing the parameters on the commandline you may
use a parameter file where the parameters are stored. The
syntax for this method is: exp <userid/password>
parfile=<filename>
Do not ignore warnings and messages! Look at your logfile
and repeat EXPORT until you get messages like:
About to export specified tables ...
. exporting table EMP 14
rows exported
. exporting table DEPT 4
rows exported
Export terminated successfully without warnings.
\
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the purpose of normalization?
C. Normalize the following data up to the 3rd Normal form. Create the tables and insert the data given. Emp_ID Name Dept_Name Salary Course_Title Date_Completed 100 Adam Marketing 48,000 SPSS 6/19/2008 Surveys 10/7/2008 140 Bob Accounting 52,000 Tax Acc 12/8/2008 110 Cathy IT SQL Server 1/12/2008 C# 4/22/2008 190 Dan Finance 150 Emily Marketing 55,000 SPSS 6/16/2008 42,000 Analysis 8/12/2008 Queries 1. Find all Names who have completed the SPSS Course. 2. Find employee with max salary. 3. Find employee with 2nd max salary. 4. Find all employees in Dept “Marketing”. 5. Find all the employees who have taken more than 2 courses. 6. Find all the employees who have completed the courses before month of September.
Show how functions and procedures are called in a pl/sql block.
How do you remove duplicate records from a table?
Why query optimization is needed?
What is the difference between microsoft access and sql server?
How can you fetch common records from two tables?
what is 'mysqlimport'? : Sql dba
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
What is trigger price?
How to select 10 records from a table?
how many ways to get the current time? : Sql dba
How do you clear the screen in sql?
what is the difference between group by and order by in sql? : Sql dba
How do we use distinct statement? What is its use?
