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!!
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...