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!!
|
Light Poster
|
|
| 2Nov2007,15:14 | #2 |
|
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...
|
|
Skilled contributor
|
 |
| 3Nov2007,08:08 | #3 |
|
I thought this to be an Introduction threads and was about to press Alt+S to welcome adroit89.
|
|
Ambitious contributor
|
|
| 5Nov2007,22:53 | #4 |
|
Quote:
Originally Posted by Izaan |