Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the statement?? ALTER TABLE TABLE_NAME MOVE;
What it the use of above statement??
- 1 Answers
- 5871 Views
- BirlaSoft, I also Faced
- E-Mail Answers
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 |
how do u setup a replication site?
From the database level, how can you tell under which time zone a database is operating?
Is primary key = unique key,not null? If yes,please explain IF No,please explain
Query to retrieve record for a many to many relationship ?
What are the four Oracle system processes that must always be up and running for the database to be useable?
I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(mini_mark) from stud_dept); How can i optimize this query. Can anyone help me with it
What is the difference between alert log file and tarce file ?
How to return top 5 rows in oracle?
How to convert csv to table in oracle?
i can create a view with two columns from emp table,, later i need to add one more emp column to existing view.. what is query similarly add one more column to existing primary key constraint.. please give me the solutions
What is a snapshot log?
How do I uninstall oracle 11g?
Oracle General 
