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 |
which institute and which faculty is providing best training for oracle sql, plsql in hyderabad
How to connect the oracle server as sysdba?
waht is referencial integrity?
How to create index-by table in oracle?
what is cartesian product?
How to define an anonymous procedure with variables?
what is difference between table and view? where to use views? thanks in advance!
What do you mean by redo log file mirroring?
What would you use to improve performance on an insert statement that places millions of rows into that table?
Create table Employee ( Employee_Id varchar2(8) Constraint emp_id_pk primary key, FirstName varchar2(50), LastName varchar2(50), DeptID Number(5) Constraint dept_id_fk Foreign Key(DeptId) References Department(DeptId) ) Error I am getting: Constraint specification are not allowed here
What is partitioned table in Oracle?
SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me