| ORACLE EXP IMP problem [message #542628] |
Wed, 08 February 2012 04:23  |
 |
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 #542901 is a reply to message #542628] |
Fri, 10 February 2012 13:06  |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
shiveclat wrote on Wed, 08 February 2012 05:23Hi
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
