How do I change owners for an Oracle Table ?
Posted on 2002-03-21
I have a large number of tables owned by an Oracle ID "PROD2DTA" - I wish to quickley change the owner to "PRODDTA". Under MS SQL Server - its possible to do this using sp_changeobjectowner - is there any way to do this in Oracle ?
I do not wish to export/import the tables - since many have >10m rows.
For anyone that solves this outright - look for bonus points !