Home » RDBMS Server » Server Utilities » Export problem
Export problem [message #70134] Fri, 19 April 2002 03:29 Go to next message
Kotapati Siva
Messages: 1
Registered: April 2002
Junior Member
Hello Everybody!
I am facing a problem in exporting a table whose name contains a dot character in it. I am using Oracle 8.0.5. Using exp80, is treating the name before the dot character as the schema name. Can anybody help in this regard.

Thanks in advance
Re: Export problem [message #70138 is a reply to message #70134] Fri, 19 April 2002 06:36 Go to previous message
Messages: 578
Registered: January 2002
Senior Member
First slap the person who created this table. Just kidding! When you do a full export the table will be picked up. The problem is if you had to restore it you would have the same problem. The only way a table could be created this way is in double quotes. I created a table called test.test and was not able to export the table either on the command line or specifying it in a parameter file. I would suggest you rename the table. It will let you do that.

SQL> rename "test.test" to test_test;

Table renamed.
Previous Topic: Java error installing Oracle 8.1.7 EE on Suse 7.2
Next Topic: Svrmgrl Is not being executed.
Goto Forum:

Current Time: Fri Mar 01 11:50:09 CST 2024