Explain the statement?? ALTER TABLE TABLE_NAME MOVE; What it the use of above s

Explain the statement?? ALTER TABLE TABLE_NAME MOVE;
What it the use of above statement??

Question Posted / vignesh

Explain the statement?? ALTER TABLE TABLE_NAME MOVE; What it the use of above statement??..

Answer / ranveeer singh

move table to other tablespace;
necessary to rebuild index if needed; command
alter index indx_name rebuild tablespace tbs_name;

Is This Answer Correct ?

6 Yes

0 No

More Oracle General Interview Questions

How would you optimize a slow SQL query?

How many types of segments in Oracle?

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

Which Functions Using Integer ==> String's i.e 2 ==> Two... Like that string's ==> integer values ? It is Possible ?

Where are the settings stored for each instance in oracle?

Explain table?

What is oracle update statement with inner join ?

what is trigger?

What is an oracle database table?

Explain oracle insert into command?

how to get count of tables in particular database in Oracle?

what is mean by prmary key and foreign key and how can we diffrentiate that? Please answer me. Advance thanks.

For more Oracle General Interview Questions Click Here