How to change owner of a table?

  • Interview Candidate
  • 6
  • 4984

Showing Answers 1 - 6 of 6 Answers

Das

  • Dec 20th, 2006
 

Owner of a table is the schema name which holds the table. To change the owner just recreate the table in the new schema and drop the previous table

chaitunitk

  • Jun 3rd, 2010
 

Owner of a table is the schema name which holds the table. To change the owner just recreate the table in the new schema
Using create table  XXX AS select * from oldschemaname.XXX
and drop the previous table in oldschema

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions