Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Rename Table (Swap)

Bahram OrujovFeb 20 2018 — edited Feb 23 2018

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).

Untitled.png

This post has been answered by Bahram Orujov on Feb 22 2018
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 23 2018
Added on Feb 20 2018
19 comments
1,264 views