create table xxx as select * from yyy, missing triggers and grants
I am performing the below query to change the tablespace of few tables in my DB
-----------------------------------------------------------------------------------------------------------
rename table1 to temp;
create table table1 tablespace tabspace1 as select * from temp;
-----------------------------------------------------------------------------------------------------------
But the grants and the triggers associated with the tables are missing after doing this.
can someone help me ??