Hi. I have two tablespacece and two table as you see. Table A is in test1 tablespace and table B is in test2 tablespace. I created table B using:
create table b as select * from A;
After that I want to rename Table B to Table A. But I don't want to lost my indexes, treiggers and all kind kind of object of old Table A.
I want to inherit all "objects" of Table A(old table A) to Table B (new table b).
