Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / rrr2009cse@gmail.com
while moving tables to the other tablespace the indexes has been unused due to movement of segments(tables). to reuse previous index on a table has to be rebuild
alter index indxname tablespace
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
Explain about your sql server dba experience? : sql server DBA
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
what is the use of recording information about current session?
What the different topologies in which replication can be configured? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
Can you redefine a table online?
Why does Oracle not permit the use of PCTUSED with indexes?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
How do you open a cluster administrator? : sql server DBA
Why would you use sql agent? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
