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
- 5955 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 |
What exactly do quotation marks around the table name do?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
how many columns can a plsql table have
How many anonymous blocks can be defined?
Explain oracle left join with an example?
What is the difference between Sleep and Wait? (Java)
What is truncate oracle?
What is varray?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
How to load excel data sheet to oracle database
What is the relation of a user account and a schema in oracle?
What are data pump export and import modes?
Oracle General 
