| Navi |
Posted: Aug 29, 2007 01:57:23 PM |
Total Post: 60
Joined: Jun, 2007
|
Hi,
I have created a table by name "Student".
SQL> select * from Student;
ID City
---------- ----------
301 Bangalore
302 Mangalore
303 Bangalore
304 Mysore
305 Bangalore
I am using Parameter file and i am trying to export only who are living in "Bangalore" to a dump file and the parameter file contains following parameters:-
File=F:\Backup_Venkat\Extonly.dmp
tables=nav.descrp
query=select * from Student where City='Bangalore'
But when i type the following command i am getting errors:-
C:\>exp nav/aaa parfile=F:\Backup_Venkat\Extonly.dmp
LRM-00112: multiple values not allowed for parameter 'query'
LRM-00113: error when processing file 'F:\Backup_Venkat\Extonly.dmp'
EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
EXP-00000: Export terminated unsuccessfully
Please guide me.
Regards,
Naveen |
|
|
 jothi |
| Posted: Sep 01, 2007 02:36:13 PM |  |
|
Total Post: 26
Joined: Aug, 2007
|
try with this
query="where city='bangalore'"
|
|
|
|
|
| nick |
| Posted: Oct 19, 2007 04:42:37 PM | |
|
Total Post: 30
Joined: Sep, 2007
|
try using:
QUERY=\"WHERE city=\'banglore'\"
|
|
|
|
|
| nick |
| Posted: Oct 19, 2007 04:42:43 PM | |
|
Total Post: 30
Joined: Sep, 2007
|
try using:
QUERY=\"WHERE city=\'banglore'\"
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
