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
DEF$_PUSHED_TRANSACTIONS
DEF$_TEMP$LOB
EMBARCADERO_EXPLAIN_PLAN
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$
LOGMNR_UID$
LOGMNR_USER$
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
MVIEW$_ADV_TEMP
MVIEW$_ADV_WORKLOAD
PLAN_TABLE
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
SQLPLUS_PRODUCT_PROFILE
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
DEF$_PUSHED_TRANSACTIONS
DEF$_TEMP$LOB
EMBARCADERO_EXPLAIN_PLAN
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$
LOGMNR_UID$
LOGMNR_USER$
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
MVIEW$_ADV_TEMP
MVIEW$_ADV_WORKLOAD
PLAN_TABLE
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
SQLPLUS_PRODUCT_PROFILE
-----Original Message-----
From: Terrian, Tom (Contractor) (DAASC) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 08, 2003 1:30 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Truncate system tables.SYSTEM not SYSalso - Oracle 9.2.0.2-----Original Message-----
From: Khedr, Waleed [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 08, 2003 1:17 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Truncate system tables.System tables means tables owned by "SYSTEM" or owned by "SYS", just making sure?Waleed-----Original Message-----
From: Terrian, Tom (Contractor) (DAASC) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 08, 2003 9:19 AM
To: Multiple recipients of list ORACLE-L
Subject: Truncate system tables.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
