| Export problem [message #70134] |
Fri, 19 April 2002 03:29  |
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  |
Grant
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
