table name with '$' character not exported via expdp utility
Hello,
After trying to export a whole user schema data, i just checked the log file and noticed that some tables were missing : all tables containing the '$' character.
So i just tried making an export test for one of them :
expdp parfile=exp_table_10g.txt
with parameter file exp_table_10g.txt containing :
userid=SYSTEM/manager@db schemas=A include=TABLE:"in ('MDRT_12BB9$')" dumpfile=Tst1.dmp logfile=tst1.log)
==>
Copyright (c) 2003, 2005, Oracle. All rights reserved.
ConnectÚ Ó : Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Product
ion
With the Partitioning, OLAP, Data Mining and Real Application Testing options
After trying to export a whole user schema data, i just checked the log file and noticed that some tables were missing : all tables containing the '$' character.
So i just tried making an export test for one of them :
expdp parfile=exp_table_10g.txt
with parameter file exp_table_10g.txt containing :
userid=SYSTEM/manager@db schemas=A include=TABLE:"in ('MDRT_12BB9$')" dumpfile=Tst1.dmp logfile=tst1.log)
==>
Copyright (c) 2003, 2005, Oracle. All rights reserved.
ConnectÚ Ó : Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Product
ion
With the Partitioning, OLAP, Data Mining and Real Application Testing options
0