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 !
Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.