| Renaming a schema [message #110738] |
Wed, 09 March 2005 22:18  |
PompeytilIDie
Messages: 9
Registered: March 2005
Location: Western Australia
|
Junior Member |
|
|
Hi,
Please can somebody recommend how to go about changing a schema name within a database (Oracle 10)?
I have a schema named wibprod and want to change it to tmsprod. I guess I can rip the necessary code out of Toad change a few name and recreate my schema objects, then do an export from one schema and an import in to the new schema, but wonder if there is a more elegant solution?
Thanks in advance 
|
|
|
|
| Re: Renaming a schema [message #110751 is a reply to message #110738] |
Thu, 10 March 2005 00:52  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
Unfortunately there is no way to rename a schema in Oracle. Best would be to create a new schema, export the old, import into the new, and drop the old schema.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
