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
5127 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

Name the various constraints used in oracle?

0 Answers

Explain what are synonyms used for?

0 Answers

What is TNS File

7 Answers Thermotech,

In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?

4 Answers Cap Gemini,

Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?

6 Answers IBM,

What is a database table in oracle?

0 Answers

Can a primary key contain more than one columns?

2 Answers

What is a snapshot log?

0 Answers

does Oracle has only one table space?

1 Answers Oracle,

How to see free space of each tablespace?

0 Answers

What is the difference between online and offline backups?

0 Answers MCN Solutions,

What is an oracle table?

0 Answers

For more Oracle General Interview Questions Click Here