Home » RDBMS Server » Server Utilities » ORACLE EXP IMP problem (11g)
ORACLE EXP IMP problem [message #542628] Wed, 08 February 2012 04:23 Go to next message
shiveclat
Messages: 19
Registered: August 2011
Location: pune
Junior Member
Hi All,
I am trying to export some records from table a to table b in same scama is it possible?
I am using following for export, but getting error ERROR 933.

expdp "$userid" tables=bca_job_currstatus query=BUSUAT1.bca_job_currstatus:\'\"where rundate=\'08-FEB-12\' \'11.45.00.000000000\' \'PM\'\"\' file=$F_DIRPATH/bca_job_currstatus.dmp

and for import

imp $userid file=bca_job_currstatus.dmp fromuser=impactmgr touser=impactmgr table=bca_history_job_currstatus

while importing the table names are different here so can we import into different table? the table structure here is same only the name is different.

can some please help me here....
Thanks
Re: ORACLE EXP IMP problem [message #542633 is a reply to message #542628] Wed, 08 February 2012 04:50 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
With 11g you can use remap_tables option with import.
But it will not rename existing tables.

Why not just use sql?
Re: ORACLE EXP IMP problem [message #542901 is a reply to message #542628] Fri, 10 February 2012 13:06 Go to previous message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
shiveclat wrote on Wed, 08 February 2012 05:23
Hi
I am using following for export, but getting error ERROR 933.

expdp "$userid" tables=bca_job_currstatus query=BUSUAT1.bca_job_currstatus:\'\"where rundate=\'08-FEB-12\' \'11.45.00.000000000\' \'PM\'\"\' file=$F_DIRPATH/bca_job_currstatus.dmp


'08-FEB-12\' \'11.45.00.000000000\' \'PM\' is a string, so unless the column rundate is a VARCHAR2, this is not correct. It also looks like an inordinate amount of single quotes if it is a VARCHAR2 column.
Previous Topic: Running into issues when using TOAD to load data using SQL Loader Wizard
Next Topic: Export from Sql server and Import into Oracle 9i
Goto Forum:
  


Current Time: Thu Mar 28 11:13:40 CDT 2024