I am running on 8.1.7.3
If I want to change the tablespace already exist in the database: How do I do it???
Is there a command
ALTER TABLE TABLE_NAME MOVE TABLESPACE TABLESPACE_NAME
Please advise
Printable View
I am running on 8.1.7.3
If I want to change the tablespace already exist in the database: How do I do it???
Is there a command
ALTER TABLE TABLE_NAME MOVE TABLESPACE TABLESPACE_NAME
Please advise
Jeff or Julian,
Do you have any advises on ALTER table command, I am sorry to rush you but I need to do this in two hours
please adivse
what is change tablespace....???
The command is:
ALTER TABLE tablename MOVE
TABLESPACE tablespacename
STORAGE (INITIAL 10m NEXT 10m PCTINCREASE 0);
After the move, rebuild the indexes.