Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Changing table owner
The Only way you can change table owner is by recreating the table in
the new schema.
eg:
login with the new schema and then
CREATE NEW_TABLE_NAME AS
--STORAGE -- if required
SELECT * FROM OLD_SCHEMA.TABLE_NAME;
Take care,
Ashok
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Oct 01 1999 - 15:44:54 CDT