Toad World® Forums

How can I change the owner of a TABLE?


#1

How exactly (!) can I change the owner of a TABLE?


View this message in context: http://old.nabble.com/How-can-I-change-the-owner-of-a-TABLE--tp27520385p27520385.html
Sent from the TOAD mailing list archive at Nabble.com.


#2

Oracle does not allow this, so the only way to do it is to create it in a
different schema, and then copy the data over.


#3

That’s like asking “How can I change the county a of town?” The
technical answer is: you can’t. The practical answer is: you create a
new town in the other county (it can have the same name as the original
town), move all the inhabitants to the new town, and then remove the old
town.

Nate Schroeder
IT Commercial Technical Services - Data Management Team
Monsanto Company
800 N. Lindbergh Blvd. G3WI - Saint Louis, MO - 63167
314-694-2592


#4