Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Changing the owner of a table ???
There is no way to simply change the owner of a table. Your best bet is to
export the two tables and do an import using fromuser=oldowner
touser=newowner. The newowner would have to be precreated and given the
necessary tablespace permissions. After the import, you could truncate the old
tables and then drop.
Terry Ball
Sr. DBA, CSG Systems
Richard Elliott wrote:
> I have a database with two very large tables and 35 smaller tables. I want
> to use export to create backups of the database. Currently I export by
> user. I want to change the user on the the two very large tables so I can
> export them separatly from the others. The two large tables are history
> tables and are only updated one a month. I know I can export by table name
> but I don't want to have to keep the list of tables names in sync with any
> changes. Can I alter the table owner and then grant all to the original
> owner, or do I have to physicaly copy the tables from old to new owner and
> then drop the old. These are VERY large tables. Thanks in advance for your
> help.
Received on Wed May 12 1999 - 08:37:12 CDT