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
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
how can you communicate with operating system files from oracle?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
internal architecture
Explain materialized views and how they are used.
when does an alert gets signaled?
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.
how can you process messages in order asynchronously?
What types of replication are supported in sql server? : sql server DBA
what do you understand by flashback feature of oracle?
What is a system database and what is a user database? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?