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

Hi Every One , What is the table Space in Oracle Database ? waiting for answere and thankyou

8 Answers

Find all employees in Dept “Marketing”.

2 Answers

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers

What do you mean by a tablespace?

0 Answers

What is concurrency in oracle?

0 Answers

How can Oracle users be audited?

0 Answers MCN Solutions,

Please explan Why static query is more faster than dynamic query ?

2 Answers

what are stored procedures?

7 Answers TCS, Wells Fargo,

What is a heap related to database ?

1 Answers TCS, University of Edinburgh,

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

0 Answers

What is the fastest query method to fetch data from the table?

0 Answers

How to change system global area (sga) in oracle?

0 Answers

For more Oracle General Interview Questions Click Here