Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Oracle (http://www.go4expert.com/forums/oracle-forum/)
-   -   hii guys!! (http://www.go4expert.com/forums/hii-guys-t6240/)

adroit89 7Sep2007 10:08

hii guys!!
 
can any one tell me the correct syntax of the query which is used to export data from database to a file.

EXP username/password@instance TABLES=(tablename)
exp scott/tiger tables=emp,bonus query="where job='SALESMAN' and
sal<1600"

this is the query which i know.But it is not working in oracle 9i version.please help!!

SIKO 2Nov2007 15:14

Re: hii guys!!
 
exp username/password@database file=C:\expfile.dmp tables = tablename full=y >for exporting all the data in the tablename you cant specify a query in exporting data u can only specify a table and will get all the data in the table with the constraints and indexes...

Izaan 3Nov2007 08:08

Re: hii guys!!
 
I thought this to be an Introduction threads and was about to press Alt+S to welcome adroit89.

Nadr 5Nov2007 22:53

Re: hii guys!!
 
Quote:

Originally Posted by Izaan
I thought this to be an Introduction threads and was about to press Alt+S to welcome adroit89.

Its just the title.


All times are GMT +5.5. The time now is 01:51.