I would like to export and import only few tables from the database to other database.
Am trying to use below commnd, but its failing with error :ORA-39071.
include=table:”in (select table_name from dba_tables where (table_name like ‘%_D%’ or table_name like ‘%_DS%’ escape ‘/’ or table_name like ‘QRT%’ )and a.owner IN (‘X’,'Y’))”
Pl let me know where i am going wrong .
Thanks in Adnavce,
The problem is you need to escape all special character when running from the command line. If you put the parameters into a parameter file you do not need to do this, so things are a lot clearer.
So from the command line you would probably need something like this:
Code: Select all
include=table:\”in (select table_name from dba_tables where (table_name like \‘%_D%\’ or table_name like \‘%_DS%\’ escape \‘/\’ or table_name like \‘QRT%\’ )and a.owner IN (\‘X\’,\'Y\’))\”
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://oracle-base.com
My blog: http://oracle-base.com/blog
Who is online
Users browsing this forum: No registered users and 4 guests