Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I accidently dropped the REPCAT$_USER_PARM_VALUES table from the system schema in my oracle db. Will it cause any problems in the future? What are these repcat$ tables for?

share|improve this question

migrated from stackoverflow.com Oct 1 '11 at 14:08

This question came from our site for professional and enthusiast programmers.

2 Answers 2

up vote 3 down vote accepted

These tables are related to Oracle Advanced Replication.

Although it is not advisable to drop them, you might just be fine if you are not using any Advanced Replication features.

Related : DBMS_REPCAT package

share|improve this answer

I accidently dropped the REPCAT$_USER_PARM_VALUES table from the system schema in my oracle db. Will it cause any problems in the future?

Unless you take steps to make sure this kind of thing doesn't happen again, you will certainly have "problems in the future". I suggest you:

  1. Tell your boss what has happened.
  2. If you are sure that is the only table that has been dropped, consider recreating it - do a dummy install on another box of the exact same version of Oracle and get the DDL from there. Even if you don't use Advanced Replication, you have no guarantee that there isn't some dependency chain that means something else isn't broken.
  3. Don't do any DDL as sys. Ever.
  4. Don't even log in as sys or system unless you are doing something that requires you to do so.
  5. Preferably leave the system and sysaux tablespaces alone - create your database objects in their own tablespaces or the default users tablespace.
share|improve this answer
    
Thanks for the answer. Though I was using test database, I'll be careful not to touch these and sorry for the late reply. –  Sanjay Nambiar Aug 29 '13 at 8:03

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.