hii guys!!

adroit89's Avatar
Go4Expert Member
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!!
0
SIKO's Avatar, Join Date: Oct 2007
Light Poster
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...
0
Izaan's Avatar, Join Date: Oct 2007
Skilled contributor
I thought this to be an Introduction threads and was about to press Alt+S to welcome adroit89.
0
Nadr's Avatar, Join Date: Oct 2007
Ambitious contributor
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.