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

1 Answers
5792 Views
BirlaSoft, I also Faced
E-Mail Answers

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

Post New Answer

More Oracle General Interview Questions

What is a directory object?

0 Answers

What is dictionary cache ?

2 Answers

What are the predefined tablespaces in a database?

0 Answers

What is Library Cache in Oracle?

0 Answers MCN Solutions,

how to do daily transactions with out sql* loader control file regesterd in apps?

0 Answers Arrow Electronics,

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

0 Answers Wipro,

Why do you create or replace procedures rather that drop and recreate.

0 Answers

What is an oracle database table?

0 Answers

Can the query output be sorted by multiple columns in oracle?

0 Answers

find out first highest salary?

10 Answers Verinon Technology Solutions,

How to lock and unlock a user account in oracle?

0 Answers

What is an Integrity Constrains ?

3 Answers

For more Oracle General Interview Questions Click Here