EXCLUDING DATA OF SOME TABLES in EXPDP [message #597498] |
Sat, 05 October 2013 03:10 |
|
sakamboh
Messages: 24 Registered: March 2013 Location: oman
|
Junior Member |
|
|
Hello,
Can anyone guide me, i want to exclude only data of some particular tables not complete table object when exporting using expdp. Will be thankful for any advise / solution.
|
|
|
|
Re: EXCLUDING DATA OF SOME TABLES in EXPDP [message #597502 is a reply to message #597498] |
Sat, 05 October 2013 03:43 |
|
sakamboh
Messages: 24 Registered: March 2013 Location: oman
|
Junior Member |
|
|
Thanks,
Please clarify the below queries as well... What needs to be changed in the below query to make it work.
expdp USER/PASS@sid schemas=scott dumpfile=ABC.dmp logfile=ABC.log query=table1,table2,table3:'"where rownum = 0"'
Its giving below error:
ORA-39001: invalid argument value
ORA-39035: Data filter SUBQUERY has already been specified.
Secondly please let me know if this can impact on resource usage and is there any performance issues that can occur if i mentioned around 10 tables in query. I am asking because i am going to execute this on my real environment.
Thanks.
[Updated on: Sat, 05 October 2013 03:49] Report message to a moderator
|
|
|
|
|
|
|
|
|
|