Export only part of data............. [message #263321] |
Wed, 29 August 2007 13:03 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
naveenkumar001
Messages: 62 Registered: July 2007 Location: Bangalore
|
Member |
![navik001](/forum/theme/orafaq/images/yahoo.png)
|
|
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
|
|
|
Re: Export only part of data............. [message #263349 is a reply to message #263321] |
Wed, 29 August 2007 15:37 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Please, read OraFAQ Forum Guide; in there you'll find how to properly ask a question (for example, Oracle database version would be useful information). Also, in there you'll find link to documentation; it will show you how to use QUERY parameter in EXP command.
Finally, it would (on my 10g) look like this:C:\>exp scott/tiger tables=emp query='where deptno = 10'
Export: Release 10.2.0.1.0 - Production on Sri Kol 29 22:31:21 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in EE8MSWIN1250 character set and AL16UTF16 NCHAR character set
About to export specified tables via Conventional Path ...
. . exporting table EMP 3 rows exported
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.
C:\>
By the way, I hope you understand that using "tables=nav.descrp" will make EXP fail if 'nav.descrp' table doesn't contain 'city' column; if you ask me, I'd use "tables=student" instead.
|
|
|
|
|
|
|
|
|