| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Truncate system tables.
Below are the tables in 9.2: (I think they come with AQ and replication)
So it depends if you were using them or not, you can rerun the individual scripts for these packages (in $ORACLE_HOME/rdbms/admin) to populate the tables in case you have not used them before.
The list can correct me if I'm mistaken.
Thanks
Waleed
TABLE_NAME
AQ$_INTERNET_AGENTS AQ$_INTERNET_AGENT_PRIVS AQ$_QUEUES AQ$_QUEUE_TABLES AQ$_SCHEDULES DEF$_AQCALL DEF$_AQERROR DEF$_CALLDEST DEF$_DEFAULTDEST DEF$_DESTINATION DEF$_ERROR DEF$_LOB DEF$_ORIGIN DEF$_PROPAGATOR
LOGMNRC_DBNAME_UID_MAP LOGMNRC_GSII LOGMNRC_GTCS LOGMNRC_GTLO LOGMNR_AGE_SPILL$ LOGMNR_ATTRCOL$ LOGMNR_ATTRIBUTE$ LOGMNR_CCOL$ LOGMNR_CDEF$ LOGMNR_COL$ LOGMNR_COLTYPE$ LOGMNR_DICTIONARY$ LOGMNR_DICTSTATE$ LOGMNR_HEADER1$ LOGMNR_HEADER2$ LOGMNR_ICOL$ LOGMNR_IND$ LOGMNR_INDCOMPART$ LOGMNR_INDPART$ LOGMNR_INDSUBPART$ LOGMNR_LOB$ LOGMNR_LOBFRAG$ LOGMNR_LOG$ LOGMNR_OBJ$ LOGMNR_PROCESSED_LOG$ LOGMNR_RESTART_CKPT$ LOGMNR_RESTART_CKPT_TXINFO$ LOGMNR_SESSION$ LOGMNR_SPILL$ LOGMNR_TAB$ LOGMNR_TABCOMPART$ LOGMNR_TABPART$ LOGMNR_TABSUBPART$ LOGMNR_TS$ LOGMNR_TYPE$
LOGSTDBY$APPLY_MILESTONE LOGSTDBY$APPLY_PROGRESS LOGSTDBY$EVENTS LOGSTDBY$PARAMETERS LOGSTDBY$PLSQL LOGSTDBY$SCN LOGSTDBY$SKIP LOGSTDBY$SKIP_SUPPORT LOGSTDBY$SKIP_TRANSACTION MVIEW$_ADV_AJG MVIEW$_ADV_BASETABLE MVIEW$_ADV_CLIQUE MVIEW$_ADV_ELIGIBLE MVIEW$_ADV_EXCEPTIONS MVIEW$_ADV_FILTER MVIEW$_ADV_FILTERINSTANCE MVIEW$_ADV_FJG MVIEW$_ADV_GC MVIEW$_ADV_INFO MVIEW$_ADV_JOURNAL MVIEW$_ADV_LEVEL MVIEW$_ADV_LOG MVIEW$_ADV_OUTPUT MVIEW$_ADV_PARAMETERS MVIEW$_ADV_PLAN MVIEW$_ADV_PRETTY MVIEW$_ADV_ROLLUP MVIEW$_ADV_SQLDEPEND
REPCAT$_AUDIT_ATTRIBUTE REPCAT$_AUDIT_COLUMN REPCAT$_COLUMN_GROUP REPCAT$_CONFLICT REPCAT$_DDL REPCAT$_EXCEPTIONS REPCAT$_EXTENSION REPCAT$_FLAVORS REPCAT$_FLAVOR_OBJECTS REPCAT$_GENERATED REPCAT$_GROUPED_COLUMN REPCAT$_INSTANTIATION_DDL REPCAT$_KEY_COLUMNS REPCAT$_OBJECT_PARMS REPCAT$_OBJECT_TYPES REPCAT$_PARAMETER_COLUMN REPCAT$_PRIORITY REPCAT$_PRIORITY_GROUP REPCAT$_REFRESH_TEMPLATES REPCAT$_REPCAT REPCAT$_REPCATLOG REPCAT$_REPCOLUMN REPCAT$_REPGROUP_PRIVS REPCAT$_REPOBJECT REPCAT$_REPPROP REPCAT$_REPSCHEMA REPCAT$_RESOLUTION REPCAT$_RESOLUTION_METHOD REPCAT$_RESOLUTION_STATISTICS REPCAT$_RESOL_STATS_CONTROL REPCAT$_RUNTIME_PARMS REPCAT$_SITES_NEW REPCAT$_SITE_OBJECTS REPCAT$_SNAPGROUP REPCAT$_TEMPLATE_OBJECTS REPCAT$_TEMPLATE_PARMS REPCAT$_TEMPLATE_REFGROUPS REPCAT$_TEMPLATE_SITES REPCAT$_TEMPLATE_STATUS REPCAT$_TEMPLATE_TARGETS REPCAT$_TEMPLATE_TYPES REPCAT$_USER_AUTHORIZATIONS REPCAT$_USER_PARM_VALUES
SYSTEM not SYS
also - Oracle 9.2.0.2
-----Original Message-----
Sent: Wednesday, January 08, 2003 1:17 PM
To: Multiple recipients of list ORACLE-L
System tables means tables owned by "SYSTEM" or owned by "SYS", just making sure?
Waleed
-----Original Message-----
Sent: Wednesday, January 08, 2003 9:19 AM
To: Multiple recipients of list ORACLE-L
ummm.......I just truncated all of the system tables in a new database (that's not good). No backups yet. Anyway to recover from this or do I have to recreate the database?
Thanks,
Tom Terrian
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Khedr, Waleed INET: Waleed.Khedr_at_FMR.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesReceived on Wed Jan 08 2003 - 13:44:11 CST
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
 |
 |