on 12-16-2015 6:56 PM
Hello guys.
I´m perfomed the Oracle Upgrade 11.2.0.2 to 11.2.0.4. in the QAS System ERP 6.0 EHP5.
When the process run with DBUA (follow the note 1431793 - Oracle 11.2.0: Upgrade Scripts) in 47% Progress show me the error:
ORA-00955: name is already used by an existing object
The trace.log in the dir E:\oracle\cfgtoollogs\dbua\QAS\upgrade4:
[BasicStep.handleNonIgnorableError:431] ORA-00955: name is already used by an existing object
:msg
[Thread-137] [ 2015-12-16 14:07:26.898 VET ] [BasicStep.handleNonIgnorableError:430] oracle.sysman.assistants.util.UIMessageHandler@6e05b24c:messageHandler
[Thread-137] [ 2015-12-16 14:07:26.898 VET ] [BasicStep.handleNonIgnorableError:431] ORA-00955: name is already used by an existing object
:msg
[Thread-137] [ 2015-12-16 14:07:31.196 VET ] [BasicStep.handleNonIgnorableError:430] oracle.sysman.assistants.util.UIMessageHandler@6e05b24c:messageHandler
[Thread-137] [ 2015-12-16 14:07:31.196 VET ] [BasicStep.handleNonIgnorableError:431] ORA-00955: name is already used by an existing object
:msg
And the Oracle_Server.log:
alter session set events '14524 trace name context forever, level 1';
CREATE TABLE SYSTEM.LOGMNR_DICTSTATE$ (
2 LOGMNR_UID NUMBER(22),
3 START_SCNBAS NUMBER,
4 START_SCNWRP NUMBER,
5 END_SCNBAS NUMBER,
6 END_SCNWRP NUMBER,
7 REDO_THREAD NUMBER,
8 RBASQN NUMBER,
9 RBABLK NUMBER,
10 RBABYTE NUMBER,
11 LOGMNR_FLAGS NUMBER(22),
12 constraint LOGMNR_DICTSTATE$_PK
13 primary key (LOGMNR_UID) disable)
14 PARTITION BY RANGE(logmnr_uid)
15 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
16 TABLESPACE SYSAUX LOGGING
17 /
CREATE TABLE SYSTEM.LOGMNR_DICTSTATE$ (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
And display more error with the same message with the others table.
What can i do?
Regards.
Desiree
Dear Desiree,
The error ORA-00955 may caused by oracle internal bug 18768955.
You can logon to DB as sysdba using SQLPlus,and run following command to check if
the object with the same structure exist on your system.
SQL> desc SYSTEM.LOGMNR_DICTSTATE$
If the table SYSTEM.LOGMNR_DICTSTATE$ already exists in your system,
then we can refer that it is okay to ignore the above error.
Best regards,
Jiajia
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Jiajia Zhang
Thanks for the replay.
The query show me:
SQL> desc SYSTEM.LOGMNR_DICTSTATE$
Name Null? Type
----------------------------------------- -------- ----------------------------
LOGMNR_UID NUMBER(22)
START_SCNBAS NUMBER
START_SCNWRP NUMBER
END_SCNBAS NUMBER
END_SCNWRP NUMBER
REDO_THREAD NUMBER
RBASQN NUMBER
RBABLK NUMBER
RBABYTE NUMBER
LOGMNR_FLAGS NUMBER(22)
In the process i´m click the buttom Ignore but not continue, and it stays there, the only option is Abort. but I do not want to mess up the process.
We can I do?
Regards.
Hello Jiajia.
Yes, when i click the button Ignore pass to the next object, but show me the same error again and not continue.
The oracle_server.log:
@?/rdbms/admin/catlmnr.sql
Rem
Rem $Header: rdbms/admin/catlmnr.sql /st_rdbms_11.2.0.4.0windbbp/2 2014/11/24 04:33:29 apfwkr Exp $
Rem
Rem catlmnr.sql
Rem
Rem Copyright (c) 2007, 2014, Oracle and/or its affiliates.
Rem All rights reserved.
Rem
Rem NAME
Rem catlmnr.sql - Create Tables and Views for Logminer
Rem
Rem DESCRIPTION
Rem This script creates logminer views and partitioned tables
Rem
Rem NOTES
Rem
Rem MODIFIED (MM/DD/YY)
Rem apfwkr 11/17/14 - Backport
Rem yunkzhan_blr_backport_19532017_11.2.0.4.0 from
Rem st_rdbms_11.2.0
Rem apfwkr 06/18/14 - Backport apfwkr_blr_backport_17381384_11.2.0.4.0
Rem from st_rdbms_11.2.0
Rem apfwkr 10/21/13 - Backport tchorma_bug-17381384 from main
Rem yunkzhan 09/29/14 - Backport yunkzhan_bug-19532017 from main
Rem abrown 02/22/13 - abrown_bp_logmnr_ggtrigger_eliminate
Rem o Bbug 14508550 - logminer metadata fixes
Rem cdb/constraints
Rem o Bug 14378546 : Logminer must track CON$
Rem o Bug 14283060: Added logmnrc_*_gg tables
Rem tchorma 09/11/13 - Bug 17381384 - Fix subquery for internal refs in
Rem logmnr_gtcs_support
Rem abrown 05/18/10 - Bug 9708526: Missing predicate for
Rem XReffedTableObjn etc.
Rem jgalanes 08/16/08 - Add logmnrC_gsba for XML FDO tracking
Rem preilly 07/17/07 - Need to get xmlintcol for special columns
Rem dvoss 06/10/08 - bug 7033630 - add logmnrc_i2gtcs
Rem dvoss 03/23/07 - bug 5867998
Rem dvoss 02/12/07 - add grant to sys
Rem dvoss 01/04/07 - Created
Rem
Rem Create partitioned Logminer tables if they do not yet exist
alter session set events '14524 trace name context forever, level 1';
CREATE TABLE SYSTEM.LOGMNR_DICTSTATE$ (
2 LOGMNR_UID NUMBER(22),
3 START_SCNBAS NUMBER,
4 START_SCNWRP NUMBER,
5 END_SCNBAS NUMBER,
6 END_SCNWRP NUMBER,
7 REDO_THREAD NUMBER,
8 RBASQN NUMBER,
9 RBABLK NUMBER,
10 RBABYTE NUMBER,
11 LOGMNR_FLAGS NUMBER(22),
12 constraint LOGMNR_DICTSTATE$_PK
13 primary key (LOGMNR_UID) disable)
14 PARTITION BY RANGE(logmnr_uid)
15 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
16 TABLESPACE SYSAUX LOGGING
17 /
CREATE TABLE SYSTEM.LOGMNR_DICTSTATE$ (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE SYSTEM.LOGMNRC_GTLO(
2 LOGMNR_UID NUMBER NOT NULL,
3 KEYOBJ# NUMBER NOT NULL,
4 LVLCNT NUMBER NOT NULL, /* level count */
5 BASEOBJ# NUMBER NOT NULL, /* base object number */
6 BASEOBJV# NUMBER NOT NULL,
7 /* base object version */
8 LVL1OBJ# NUMBER, /* level 1 object number */
9 LVL2OBJ# NUMBER, /* level 2 object number */
10 LVL0TYPE# NUMBER NOT NULL,
11 /* level 0 (base obj) type # */
12 LVL1TYPE# NUMBER, /* level 1 type # */
13 LVL2TYPE# NUMBER, /* level 2 type # */
14 OWNER# NUMBER, /* owner number */
15 OWNERNAME VARCHAR2(30) NOT NULL,
16 LVL0NAME VARCHAR2(30) NOT NULL,
17 /* name of level 0 (base obj) */
18 LVL1NAME VARCHAR2(30), /* name of level 1 object */
19 LVL2NAME VARCHAR2(30), /* name of level 2 object */
20 INTCOLS NUMBER NOT NULL,
21 /* for table object, number of all types cols */
22 COLS NUMBER,
23 /* for table object, number of user visable cols */
24 KERNELCOLS NUMBER,
25 /* for table object, number of non zero secol# cols */
26 TAB_FLAGS NUMBER, /* TAB$.FLAGS */
27 TRIGFLAG NUMBER, /* TAB$.TRIGFLAG */
28 ASSOC# NUMBER, /* IOT/OF Associated object */
29 OBJ_FLAGS NUMBER, /* OBJ$.FLAGS */
30 TS# NUMBER, /* table space number */
31 TSNAME VARCHAR2(30), /* table space name */
32 PROPERTY NUMBER,
33 /* Replication Dictionary Specific Columns */
34 START_SCN NUMBER NOT NULL,
35 /* SCN at which existence begins */
36 DROP_SCN NUMBER, /* SCN at which existence ends */
37 XIDUSN NUMBER,
38 /* src txn which created this object */
39 XIDSLT NUMBER,
40 XIDSQN NUMBER,
41 FLAGS NUMBER,
42 LOGMNR_SPARE1 NUMBER,
43 LOGMNR_SPARE2 NUMBER,
44 LOGMNR_SPARE3 VARCHAR2(1000),
45 LOGMNR_SPARE4 DATE,
46 LOGMNR_SPARE5 NUMBER,
47 LOGMNR_SPARE6 NUMBER,
48 LOGMNR_SPARE7 NUMBER,
49 LOGMNR_SPARE8 NUMBER,
50 LOGMNR_SPARE9 NUMBER,
51 /* New in V11 */
52 PARTTYPE NUMBER,
53 SUBPARTTYPE NUMBER,
54 UNSUPPORTEDCOLS NUMBER,
55 COMPLEXTYPECOLS NUMBER,
56 NTPARENTOBJNUM NUMBER,
57 NTPARENTOBJVERSION NUMBER,
58 NTPARENTINTCOLNUM NUMBER,
59 LOGMNRTLOFLAGS NUMBER,
60 LOGMNRMCV VARCHAR2(30),
61 CONSTRAINT LOGMNRC_GTLO_PK
62 PRIMARY KEY(LOGMNR_UID, KEYOBJ#, BASEOBJV#)
63 USING INDEX LOCAL
64 ) PARTITION BY RANGE(logmnr_uid)
65 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
66 TABLESPACE SYSAUX LOGGING
67 /
CREATE TABLE SYSTEM.LOGMNRC_GTLO(
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNRC_I2GTLO
2 ON SYSTEM.LOGMNRC_GTLO (logmnr_uid, baseobj#, baseobjv#)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNRC_I2GTLO
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNRC_I3GTLO
2 ON SYSTEM.LOGMNRC_GTLO (logmnr_uid, drop_scn)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNRC_I3GTLO
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE SYSTEM.LOGMNRC_GTCS(
2 LOGMNR_UID NUMBER NOT NULL,
3 OBJ# NUMBER NOT NULL,
4 /* table (base) object number */
5 OBJV# NUMBER NOT NULL,
6 /* table object version */
7 SEGCOL# NUMBER NOT NULL,
8 /* segcol# of column */
9 INTCOL# NUMBER NOT NULL,
10 /* intcol# of column */
11 COLNAME VARCHAR2(30) NOT NULL,
12 /* name of column */
13 TYPE# NUMBER NOT NULL, /* column type */
14 LENGTH NUMBER, /* data length */
15 PRECISION NUMBER, /* data precision */
16 SCALE NUMBER, /* data scale */
17 INTERVAL_LEADING_PRECISION NUMBER,
18 /* Interval Leading Precision, if any */
19 INTERVAL_TRAILING_PRECISION NUMBER,
20 /* Interval trailing precision, if any */
21 PROPERTY NUMBER,
22 TOID RAW(16),
23 CHARSETID NUMBER,
24 CHARSETFORM NUMBER,
25 TYPENAME VARCHAR2(30),
26 FQCOLNAME VARCHAR2(4000),
27 /* fully-qualified column name */
28 NUMINTCOLS NUMBER, /* Number of Int Cols */
29 NUMATTRS NUMBER,
30 ADTORDER NUMBER,
31 LOGMNR_SPARE1 NUMBER,
32 LOGMNR_SPARE2 NUMBER,
33 LOGMNR_SPARE3 VARCHAR2(1000),
34 LOGMNR_SPARE4 DATE,
35 LOGMNR_SPARE5 NUMBER,
36 LOGMNR_SPARE6 NUMBER,
37 LOGMNR_SPARE7 NUMBER,
38 LOGMNR_SPARE8 NUMBER,
39 LOGMNR_SPARE9 NUMBER,
40 /* New for V11. */
41 COL# NUMBER,
42 XTYPESCHEMANAME VARCHAR2(30),
43 XTYPENAME VARCHAR2(4000),
44 XFQCOLNAME VARCHAR2(4000),
45 XTOPINTCOL NUMBER,
46 XREFFEDTABLEOBJN NUMBER,
47 XREFFEDTABLEOBJV NUMBER,
48 XCOLTYPEFLAGS NUMBER,
49 XOPQTYPETYPE NUMBER,
50 XOPQTYPEFLAGS NUMBER,
51 XOPQLOBINTCOL NUMBER,
52 XOPQOBJINTCOL NUMBER,
53 XXMLINTCOL NUMBER,
54 EAOWNER# NUMBER,
55 EAMKEYID VARCHAR2(64),
56 EAENCALG NUMBER,
57 EAINTALG NUMBER,
58 EACOLKLC RAW(2000),
59 EAKLCLEN NUMBER,
60 EAFLAGS NUMBER,
61 constraint logmnrc_gtcs_pk
62 primary key(logmnr_uid, obj#, objv#,intcol#)
63 using index local
64 ) PARTITION BY RANGE(logmnr_uid)
65 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
66 TABLESPACE SYSAUX LOGGING
67 /
CREATE TABLE SYSTEM.LOGMNRC_GTCS(
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
Rem Note the following index may not exist prior to 11.1.0.7.
CREATE INDEX SYSTEM.LOGMNRC_I2GTCS
2 ON SYSTEM.LOGMNRC_GTCS (logmnr_uid, obj#, objv#, segcol#, intcol#)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNRC_I2GTCS
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
Rem
Rem LOGMNRC_SEQ_GG is a table to hold sequence related information for GG.
Rem This is versioned by the commit_scn of the ddl.
Rem Sequences are versioned on every ddl on them. Each ddl on a sequence
Rem pushes a row into this table that contains the before image of the ddl.
Rem SEQ_FLAGS is a bit field column whose bits can be
Rem SEQ_CYCLE - derived from seq$.cycle#
Rem SEQ_ORDER - derived from seq$.order$
CREATE TABLE SYSTEM.LOGMNRC_SEQ_GG (
2 LOGMNR_UID NUMBER NOT NULL,
3 OBJ# NUMBER NOT NULL,
4 COMMIT_SCN NUMBER NOT NULL,
5 DROP_SCN NUMBER,
6 SEQ_FLAGS NUMBER NOT NULL,
7 OWNER# NUMBER NOT NULL,
8 OWNERNAME VARCHAR2(128) NOT NULL,
9 OBJNAME VARCHAR2(128) NOT NULL,
10 SEQCACHE NUMBER, /* Used for sequences */
11 SEQINC NUMBER,
12 SPARE1 NUMBER,
13 SPARE2 NUMBER,
14 SPARE3 VARCHAR(4000),
15 SPARE4 VARCHAR(4000),
16 constraint logmnrc_seq_gg_pk
17 primary key(logmnr_uid, obj#,commit_scn)
18 using index local
19 ) PARTITION BY RANGE(logmnr_uid)
20 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
21 TABLESPACE SYSAUX LOGGING
22 /
CREATE TABLE SYSTEM.LOGMNRC_SEQ_GG (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNRC_I2SEQGG
2 ON SYSTEM.LOGMNRC_SEQ_GG (logmnr_uid, drop_scn)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNRC_I2SEQGG
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
Rem
Rem LOGMNRC_CON_GG is a table to hold the constraint information
Rem tracked by SCN.
Rem
CREATE TABLE SYSTEM.LOGMNRC_CON_GG (
2 LOGMNR_UID NUMBER NOT NULL,
3 CON# NUMBER NOT NULL,
4 NAME VARCHAR2(128) NOT NULL,
5 COMMIT_SCN NUMBER NOT NULL,
6 DROP_SCN NUMBER,
7 BASEOBJ# NUMBER NOT NULL,
8 BASEOBJV# NUMBER NOT NULL,
9 FLAGS NUMBER NOT NULL,
10 INDEXOBJ# NUMBER,
11 SPARE1 NUMBER,
12 SPARE2 NUMBER,
13 SPARE3 NUMBER,
14 SPARE4 VARCHAR2(4000),
15 SPARE5 VARCHAR2(4000),
16 SPARE6 VARCHAR2(4000),
17 constraint logmnrc_con_gg_pk
18 primary key(logmnr_uid, con#, commit_scn)
19 using index local
20 ) PARTITION BY RANGE(logmnr_uid)
21 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
22 TABLESPACE SYSAUX LOGGING
23 /
CREATE TABLE SYSTEM.LOGMNRC_CON_GG (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNRC_I1CONGG
2 ON SYSTEM.LOGMNRC_CON_GG (logmnr_uid, baseobj#, baseobjv#, commit_scn)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNRC_I1CONGG
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNRC_I2CONGG
2 ON SYSTEM.LOGMNRC_CON_GG (logmnr_uid, drop_scn)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNRC_I2CONGG
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
Rem
Rem LOGMNRC_CONCOL_GG would contain the column information of the
Rem constraints pushed into LOGMNRC_CON_GG.
Rem
CREATE TABLE SYSTEM.LOGMNRC_CONCOL_GG (
2 LOGMNR_UID NUMBER NOT NULL,
3 CON# NUMBER NOT NULL,
4 COMMIT_SCN NUMBER NOT NULL,
5 INTCOL# NUMBER NOT NULL,
6 POS# NUMBER,
7 SPARE1 NUMBER,
8 SPARE2 NUMBER,
9 SPARE3 VARCHAR2(4000),
10 constraint logmnrc_concol_gg_pk
11 primary key(logmnr_uid, con#, commit_scn, intcol#)
12 using index local
13 ) PARTITION BY RANGE(logmnr_uid)
14 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
15 TABLESPACE SYSAUX LOGGING
16 /
CREATE TABLE SYSTEM.LOGMNRC_CONCOL_GG (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
Rem
Rem LOGMNRC_IND_GG is a table to hold the index information
Rem tracked by SCN.
Rem
CREATE TABLE SYSTEM.LOGMNRC_IND_GG (
2 LOGMNR_UID NUMBER NOT NULL,
3 OBJ# NUMBER NOT NULL,
4 NAME VARCHAR2(128) NOT NULL,
5 COMMIT_SCN NUMBER NOT NULL,
6 DROP_SCN NUMBER,
7 BASEOBJ# NUMBER NOT NULL,
8 BASEOBJV# NUMBER NOT NULL,
9 FLAGS NUMBER NOT NULL,
10 OWNER# NUMBER NOT NULL,
11 OWNERNAME VARCHAR2(128) NOT NULL,
12 SPARE1 NUMBER,
13 SPARE2 NUMBER,
14 SPARE3 NUMBER,
15 SPARE4 VARCHAR2(4000),
16 SPARE5 VARCHAR2(4000),
17 SPARE6 VARCHAR2(4000),
18 constraint logmnrc_ind_gg_pk
19 primary key(logmnr_uid, obj#, commit_scn)
20 using index local
21 ) PARTITION BY RANGE(logmnr_uid)
22 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
23 TABLESPACE SYSAUX LOGGING
24 /
CREATE TABLE SYSTEM.LOGMNRC_IND_GG (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNRC_I1INDGG
2 ON SYSTEM.LOGMNRC_IND_GG (logmnr_uid, baseobj#, baseobjv#, commit_scn)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNRC_I1INDGG
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNRC_I2INDGG
2 ON SYSTEM.LOGMNRC_IND_GG (logmnr_uid, drop_scn)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNRC_I2INDGG
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
Rem
Rem LOGMNRC_INDCOL_GG would contain the column information of the indexes
Rem pushed into LOGMNRC_IND_GG.
Rem
CREATE TABLE SYSTEM.LOGMNRC_INDCOL_GG (
2 LOGMNR_UID NUMBER NOT NULL,
3 OBJ# NUMBER NOT NULL,
4 COMMIT_SCN NUMBER NOT NULL,
5 INTCOL# NUMBER NOT NULL,
6 POS# NUMBER NOT NULL,
7 SPARE1 NUMBER,
8 SPARE2 NUMBER,
9 SPARE3 VARCHAR2(4000),
10 constraint logmnrc_indcol_gg_pk
11 primary key(logmnr_uid, obj#, commit_scn, intcol#)
12 using index local
13 ) PARTITION BY RANGE(logmnr_uid)
14 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
15 TABLESPACE SYSAUX LOGGING
16 /
CREATE TABLE SYSTEM.LOGMNRC_INDCOL_GG (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE SYSTEM.LOGMNRC_GSII(
2 LOGMNR_UID NUMBER NOT NULL,
3 OBJ# NUMBER NOT NULL,
4 BO# NUMBER NOT NULL,
5 INDTYPE# NUMBER NOT NULL,
6 DROP_SCN NUMBER,
7 LOGMNR_SPARE1 NUMBER,
8 LOGMNR_SPARE2 NUMBER,
9 LOGMNR_SPARE3 VARCHAR2(1000),
10 LOGMNR_SPARE4 DATE,
11 constraint logmnrc_gsii_pk primary key(logmnr_uid, obj#)
12 using index local
13 ) PARTITION BY RANGE(logmnr_uid)
14 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
15 TABLESPACE SYSAUX LOGGING
16 /
CREATE TABLE SYSTEM.LOGMNRC_GSII(
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE SYSTEM.LOGMNRC_GSBA(
2 LOGMNR_UID NUMBER NOT NULL,
3 AS_OF_SCN NUMBER NOT NULL,
4 FDO_LENGTH NUMBER,
5 FDO_VALUE RAW(255),
6 CHARSETID NUMBER,
7 NCHARSETID NUMBER,
8 DBTIMEZONE_LEN NUMBER,
9 DBTIMEZONE_VALUE VARCHAR2(64),
10 LOGMNR_SPARE1 NUMBER,
11 LOGMNR_SPARE2 NUMBER,
12 LOGMNR_SPARE3 VARCHAR2(1000),
13 LOGMNR_SPARE4 DATE,
14 constraint logmnrc_gsba_pk
15 primary key(logmnr_uid, as_of_scn)
16 using index local
17 ) PARTITION BY RANGE(logmnr_uid)
18 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
19 TABLESPACE SYSAUX LOGGING
20 /
CREATE TABLE SYSTEM.LOGMNRC_GSBA(
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE SYSTEM.LOGMNR_SEED$ (
2 SEED_VERSION NUMBER(22),
3 GATHER_VERSION NUMBER(22),
4 SCHEMANAME VARCHAR2(30),
5 OBJ# NUMBER,
6 OBJV# NUMBER(22),
7 TABLE_NAME VARCHAR2(30),
8 COL_NAME VARCHAR2(30),
9 COL# NUMBER,
10 INTCOL# NUMBER,
11 SEGCOL# NUMBER,
12 TYPE# NUMBER,
13 LENGTH NUMBER,
14 PRECISION# NUMBER,
15 SCALE NUMBER,
16 NULL$ NUMBER NOT NULL,
17 logmnr_uid NUMBER(22),
18 logmnr_flags NUMBER(22),
19 constraint LOGMNR_SEED$_pk
20 primary key (LOGMNR_UID, OBJ#, INTCOL#) disable )
21 PARTITION BY RANGE(logmnr_uid)
22 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
23 TABLESPACE SYSAUX LOGGING
24 /
CREATE TABLE SYSTEM.LOGMNR_SEED$ (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I1SEED$
2 ON SYSTEM.LOGMNR_SEED$ (LOGMNR_UID, OBJ#, INTCOL#)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I1SEED$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I2SEED$
2 ON SYSTEM.LOGMNR_SEED$ (logmnr_uid, schemaname, table_name,
3 col_name, obj#, intcol#)
4 TABLESPACE SYSAUX LOCAL LOGGING
5 /
CREATE INDEX SYSTEM.LOGMNR_I2SEED$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE SYSTEM.LOGMNR_DICTIONARY$ (
2 DB_NAME VARCHAR2(9),
3 DB_ID NUMBER(20),
4 DB_CREATED VARCHAR2(20),
5 DB_DICT_CREATED VARCHAR2(20),
6 DB_DICT_SCN NUMBER(22),
7 DB_THREAD_MAP RAW(8),
8 DB_TXN_SCNBAS NUMBER(22),
9 DB_TXN_SCNWRP NUMBER(22),
10 DB_RESETLOGS_CHANGE# NUMBER(22),
11 DB_RESETLOGS_TIME VARCHAR2(20),
12 DB_VERSION_TIME VARCHAR2(20),
13 DB_REDO_TYPE_ID VARCHAR2(8),
14 DB_REDO_RELEASE VARCHAR2(60),
15 DB_CHARACTER_SET VARCHAR2(30),
16 DB_VERSION VARCHAR2(64),
17 DB_STATUS VARCHAR2(64),
18 DB_GLOBAL_NAME VARCHAR(128),
19 DB_DICT_MAXOBJECTS NUMBER(22),
20 DB_DICT_OBJECTCOUNT NUMBER(22) NOT NULL,
21 logmnr_uid NUMBER(22),
22 logmnr_flags NUMBER(22),
23 constraint LOGMNR_DICTIONARY$_pk primary key (LOGMNR_UID) disable )
24 PARTITION BY RANGE(logmnr_uid)
25 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
26 TABLESPACE SYSAUX LOGGING
27 /
CREATE TABLE SYSTEM.LOGMNR_DICTIONARY$ (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I1DICTIONARY$
2 ON SYSTEM.LOGMNR_DICTIONARY$ (LOGMNR_UID)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I1DICTIONARY$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE SYSTEM.LOGMNR_OBJ$ (
2 OBJV# NUMBER(22),
3 OWNER# NUMBER(22),
4 NAME VARCHAR2(30),
5 NAMESPACE NUMBER(22),
6 SUBNAME VARCHAR2(30),
7 TYPE# NUMBER(22),
8 OID$ RAW(16),
9 REMOTEOWNER VARCHAR2(30),
10 LINKNAME VARCHAR(128),
11 FLAGS NUMBER(22),
12 SPARE3 NUMBER(22),
13 STIME DATE,
14 OBJ# NUMBER(22) NOT NULL,
15 logmnr_uid NUMBER(22),
16 logmnr_flags NUMBER(22),
17 START_SCNBAS NUMBER,
18 START_SCNWRP NUMBER,
19 constraint LOGMNR_OBJ$_pk primary key (LOGMNR_UID, OBJ#) disable )
20 PARTITION BY RANGE(logmnr_uid)
21 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
22 TABLESPACE SYSAUX LOGGING
23 /
CREATE TABLE SYSTEM.LOGMNR_OBJ$ (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I1OBJ$
2 ON SYSTEM.LOGMNR_OBJ$ (LOGMNR_UID, OBJ#)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I1OBJ$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I2OBJ$
2 ON SYSTEM.LOGMNR_OBJ$ (logmnr_uid, oid$)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I2OBJ$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE SYSTEM.LOGMNR_TAB$ (
2 TS# NUMBER(22),
3 COLS NUMBER(22),
4 PROPERTY NUMBER(22),
5 INTCOLS NUMBER(22),
6 KERNELCOLS NUMBER(22),
7 BOBJ# NUMBER(22),
8 TRIGFLAG NUMBER(22),
9 FLAGS NUMBER(22),
10 OBJ# NUMBER(22) NOT NULL,
11 logmnr_uid NUMBER(22),
12 logmnr_flags NUMBER(22),
13 constraint LOGMNR_TAB$_pk primary key (LOGMNR_UID, OBJ#) disable )
14 PARTITION BY RANGE(logmnr_uid)
15 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
16 TABLESPACE SYSAUX LOGGING
17 /
CREATE TABLE SYSTEM.LOGMNR_TAB$ (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I1TAB$
2 ON SYSTEM.LOGMNR_TAB$ (LOGMNR_UID, OBJ#)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I1TAB$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I2TAB$
2 ON SYSTEM.LOGMNR_TAB$ (logmnr_uid, bobj#)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I2TAB$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE SYSTEM.LOGMNR_COL$ (
2 COL# NUMBER(22),
3 SEGCOL# NUMBER(22),
4 NAME VARCHAR2(30),
5 TYPE# NUMBER(22),
6 LENGTH NUMBER(22),
7 PRECISION# NUMBER(22),
8 SCALE NUMBER(22),
9 NULL$ NUMBER(22),
10 INTCOL# NUMBER(22),
11 PROPERTY NUMBER(22),
12 CHARSETID NUMBER(22),
13 CHARSETFORM NUMBER(22),
14 SPARE1 NUMBER(22),
15 SPARE2 NUMBER(22),
16 OBJ# NUMBER(22) NOT NULL,
17 logmnr_uid NUMBER(22),
18 logmnr_flags NUMBER(22),
19 constraint LOGMNR_COL$_pk
20 primary key (LOGMNR_UID, OBJ#, INTCOL#) disable )
21 PARTITION BY RANGE(logmnr_uid)
22 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
23 TABLESPACE SYSAUX LOGGING
24 /
CREATE TABLE SYSTEM.LOGMNR_COL$ (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I1COL$
2 ON SYSTEM.LOGMNR_COL$ (LOGMNR_UID, OBJ#, INTCOL#)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I1COL$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I2COL$
2 ON SYSTEM.LOGMNR_COL$ (logmnr_uid, obj#, name)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I2COL$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I3COL$
2 ON SYSTEM.LOGMNR_COL$ (logmnr_uid, obj#, col#)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I3COL$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE SYSTEM.LOGMNR_ATTRCOL$ (
2 INTCOL# number,
3 NAME varchar2(4000),
4 OBJ# number NOT NULL,
5 logmnr_uid NUMBER(22),
6 logmnr_flags NUMBER(22),
7 constraint LOGMNR_ATTRCOL$_pk
8 primary key (LOGMNR_UID, OBJ#, INTCOL#) disable )
9 PARTITION BY RANGE(logmnr_uid)
10 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
11 TABLESPACE SYSAUX LOGGING
12 /
CREATE TABLE SYSTEM.LOGMNR_ATTRCOL$ (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I1ATTRCOL$
2 ON SYSTEM.LOGMNR_ATTRCOL$ (LOGMNR_UID, OBJ#, INTCOL#)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I1ATTRCOL$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE SYSTEM.LOGMNR_TS$ (
2 TS# NUMBER(22),
3 NAME VARCHAR2(30),
4 OWNER# NUMBER(22),
5 BLOCKSIZE NUMBER(22) NOT NULL,
6 logmnr_uid NUMBER(22),
7 logmnr_flags NUMBER(22),
8 constraint LOGMNR_TS$_pk primary key (LOGMNR_UID, TS#) disable )
9 PARTITION BY RANGE(logmnr_uid)
10 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
11 TABLESPACE SYSAUX LOGGING
12 /
CREATE TABLE SYSTEM.LOGMNR_TS$ (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I1TS$
2 ON SYSTEM.LOGMNR_TS$ (LOGMNR_UID, TS#)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I1TS$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE SYSTEM.LOGMNR_IND$ (
2 BO# NUMBER(22),
3 COLS NUMBER(22),
4 TYPE# NUMBER(22),
5 FLAGS NUMBER,
6 PROPERTY NUMBER,
7 OBJ# NUMBER(22) NOT NULL,
8 logmnr_uid NUMBER(22),
9 logmnr_flags NUMBER(22),
10 constraint LOGMNR_IND$_pk primary key (LOGMNR_UID, OBJ#) disable )
11 PARTITION BY RANGE(logmnr_uid)
12 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
13 TABLESPACE SYSAUX LOGGING
14 /
CREATE TABLE SYSTEM.LOGMNR_IND$ (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I1IND$
2 ON SYSTEM.LOGMNR_IND$ (LOGMNR_UID, OBJ#)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I1IND$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I2IND$
2 ON SYSTEM.LOGMNR_IND$ (LOGMNR_UID, BO#)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I2IND$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE SYSTEM.LOGMNR_USER$ (
2 USER# NUMBER(22),
3 NAME VARCHAR2(30) NOT NULL,
4 logmnr_uid NUMBER(22),
5 logmnr_flags NUMBER(22),
6 constraint LOGMNR_USER$_pk primary key (LOGMNR_UID, USER#) disable )
7 PARTITION BY RANGE(logmnr_uid)
8 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
9 TABLESPACE SYSAUX LOGGING
10 /
CREATE TABLE SYSTEM.LOGMNR_USER$ (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I1USER$
2 ON SYSTEM.LOGMNR_USER$ (LOGMNR_UID, USER#)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I1USER$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE SYSTEM.LOGMNR_TABPART$ (
2 OBJ# NUMBER(22),
3 TS# NUMBER(22),
4 PART# NUMBER,
5 BO# NUMBER(22) NOT NULL,
6 logmnr_uid NUMBER(22),
7 logmnr_flags NUMBER(22),
8 constraint LOGMNR_TABPART$_pk
9 primary key (LOGMNR_UID, OBJ#, BO#) disable )
10 PARTITION BY RANGE(logmnr_uid)
11 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
12 TABLESPACE SYSAUX LOGGING
13 /
CREATE TABLE SYSTEM.LOGMNR_TABPART$ (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I1TABPART$
2 ON SYSTEM.LOGMNR_TABPART$ (LOGMNR_UID, OBJ#, BO#)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I1TABPART$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I2TABPART$
2 ON SYSTEM.LOGMNR_TABPART$ (logmnr_uid, bo#)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I2TABPART$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE SYSTEM.LOGMNR_TABSUBPART$ (
2 OBJ# NUMBER(22),
3 DATAOBJ# NUMBER(22),
4 POBJ# NUMBER(22),
5 SUBPART# NUMBER(22),
6 TS# NUMBER(22) NOT NULL,
7 logmnr_uid NUMBER(22),
8 logmnr_flags NUMBER(22),
9 constraint LOGMNR_TABSUBPART$_pk
10 primary key (LOGMNR_UID, OBJ#, POBJ#) disable )
11 PARTITION BY RANGE(logmnr_uid)
12 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
13 TABLESPACE SYSAUX LOGGING
14 /
CREATE TABLE SYSTEM.LOGMNR_TABSUBPART$ (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I1TABSUBPART$
2 ON SYSTEM.LOGMNR_TABSUBPART$ (LOGMNR_UID, OBJ#, POBJ#)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I1TABSUBPART$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I2TABSUBPART$
2 ON SYSTEM.LOGMNR_TABSUBPART$ (logmnr_uid, pobj#)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I2TABSUBPART$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE SYSTEM.LOGMNR_TABCOMPART$ (
2 OBJ# NUMBER(22),
3 BO# NUMBER(22),
4 PART# NUMBER(22) NOT NULL,
5 logmnr_uid NUMBER(22),
6 logmnr_flags NUMBER(22),
7 constraint LOGMNR_TABCOMPART$_pk
8 primary key (LOGMNR_UID, OBJ#) disable )
9 PARTITION BY RANGE(logmnr_uid)
10 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
11 TABLESPACE SYSAUX LOGGING
12 /
CREATE TABLE SYSTEM.LOGMNR_TABCOMPART$ (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I1TABCOMPART$
2 ON SYSTEM.LOGMNR_TABCOMPART$ (LOGMNR_UID, OBJ#)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I1TABCOMPART$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I2TABCOMPART$
2 ON SYSTEM.LOGMNR_TABCOMPART$ (logmnr_uid, bo#)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I2TABCOMPART$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE SYSTEM.LOGMNR_TYPE$ (
2 version# number,
3 version varchar2(30),
4 tvoid raw(16),
5 typecode number,
6 properties number,
7 attributes number,
8 methods number,
9 hiddenMethods number,
10 supertypes number,
11 subtypes number,
12 externtype number,
13 externname varchar2(4000),
14 helperclassname varchar2(4000),
15 local_attrs number,
16 local_methods number,
17 typeid raw(16),
18 roottoid raw(16),
19 spare1 number,
20 spare2 number,
21 spare3 number,
22 supertoid raw(16),
23 hashcode raw(17),
24 toid raw(16) not null,
25 logmnr_uid NUMBER(22),
26 logmnr_flags NUMBER(22),
27 constraint LOGMNR_TYPE$_pk
28 primary key (LOGMNR_UID, TOID, VERSION#) disable )
29 PARTITION BY RANGE(logmnr_uid)
30 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
31 TABLESPACE SYSAUX LOGGING
32 /
CREATE TABLE SYSTEM.LOGMNR_TYPE$ (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I1TYPE$
2 ON SYSTEM.LOGMNR_TYPE$ (LOGMNR_UID, TOID, VERSION#)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I1TYPE$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE SYSTEM.LOGMNR_COLTYPE$ (
2 col# number,
3 intcol# number,
4 toid raw(16),
5 version# number,
6 packed number,
7 intcols number,
8 intcol#s raw(2000),
9 flags number,
10 typidcol# number,
11 synobj# number,
12 obj# number not null,
13 logmnr_uid NUMBER(22),
14 logmnr_flags NUMBER(22),
15 constraint LOGMNR_COLTYPE$_pk
16 primary key (LOGMNR_UID, OBJ#, INTCOL#) disable )
17 PARTITION BY RANGE(logmnr_uid)
18 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
19 TABLESPACE SYSAUX LOGGING
20 /
CREATE TABLE SYSTEM.LOGMNR_COLTYPE$ (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I1COLTYPE$
2 ON SYSTEM.LOGMNR_COLTYPE$ (LOGMNR_UID, OBJ#, INTCOL#)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I1COLTYPE$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE SYSTEM.LOGMNR_ATTRIBUTE$ (
2 version# number,
3 name varchar2(30),
4 attribute# number,
5 attr_toid raw(16),
6 attr_version# number,
7 synobj# number,
8 properties number,
9 charsetid number,
10 charsetform number,
11 length number,
12 precision# number,
13 scale number,
14 externname varchar2(4000),
15 xflags number,
16 spare1 number,
17 spare2 number,
18 spare3 number,
19 spare4 number,
20 spare5 number,
21 setter number,
22 getter number,
23 toid raw(16) not null,
24 logmnr_uid NUMBER(22),
25 logmnr_flags NUMBER(22),
26 constraint LOGMNR_ATTRIBUTE$_pk
27 primary key (LOGMNR_UID, TOID, VERSION#, ATTRIBUTE#) disable )
28 PARTITION BY RANGE(logmnr_uid)
29 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
30 TABLESPACE SYSAUX LOGGING
31 /
CREATE TABLE SYSTEM.LOGMNR_ATTRIBUTE$ (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I1ATTRIBUTE$
2 ON SYSTEM.LOGMNR_ATTRIBUTE$ (LOGMNR_UID, TOID, VERSION#, ATTRIBUTE#)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I1ATTRIBUTE$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE SYSTEM.LOGMNR_LOB$ (
2 OBJ# NUMBER,
3 INTCOL# NUMBER,
4 COL# NUMBER,
5 LOBJ# NUMBER,
6 CHUNK NUMBER NOT NULL,
7 logmnr_uid NUMBER(22),
8 logmnr_flags NUMBER(22),
9 constraint LOGMNR_LOB$_pk
10 primary key (LOGMNR_UID, OBJ#, INTCOL#) disable )
11 PARTITION BY RANGE(logmnr_uid)
12 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
13 TABLESPACE SYSAUX LOGGING
14 /
CREATE TABLE SYSTEM.LOGMNR_LOB$ (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I1LOB$
2 ON SYSTEM.LOGMNR_LOB$ (LOGMNR_UID, OBJ#, INTCOL#)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I1LOB$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE SYSTEM.LOGMNR_CON$ (
2 owner# number not null,
3 name varchar2(128) not null,
4 con# number not null,
5 logmnr_uid number(22),
6 logmnr_flags number(22),
7 start_scnbas number,
8 start_scnwrp number,
9 constraint logmnr_con$_pk
10 primary key (LOGMNR_UID, CON#) disable )
11 PARTITION BY RANGE(logmnr_uid)
12 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
13 TABLESPACE SYSAUX LOGGING
14 /
CREATE TABLE SYSTEM.LOGMNR_CON$ (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I1CON$
2 ON SYSTEM.LOGMNR_CON$ (LOGMNR_UID, CON#)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I1CON$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE SYS.LOGMNRG_CON$ (
2 OWNER# NUMBER NOT NULL,
3 NAME VARCHAR2(128) NOT NULL,
4 CON# NUMBER NOT NULL )
5 TABLESPACE SYSTEM LOGGING
6 /
CREATE TABLE SYS.LOGMNRG_CON$ (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE SYSTEM.LOGMNR_CDEF$ (
2 CON# NUMBER,
3 COLS NUMBER,
4 TYPE# NUMBER,
5 ROBJ# NUMBER,
6 RCON# NUMBER,
7 ENABLED NUMBER,
8 DEFER NUMBER,
9 OBJ# NUMBER NOT NULL,
10 logmnr_uid NUMBER(22),
11 logmnr_flags NUMBER(22),
12 constraint LOGMNR_CDEF$_pk primary key (LOGMNR_UID, CON#) disable )
13 PARTITION BY RANGE(logmnr_uid)
14 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
15 TABLESPACE SYSAUX LOGGING
16 /
CREATE TABLE SYSTEM.LOGMNR_CDEF$ (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I1CDEF$
2 ON SYSTEM.LOGMNR_CDEF$ (LOGMNR_UID, CON#)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I1CDEF$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I2CDEF$
2 ON SYSTEM.LOGMNR_CDEF$ (LOGMNR_UID, ROBJ#)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I2CDEF$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I3CDEF$
2 ON SYSTEM.LOGMNR_CDEF$ (LOGMNR_UID, OBJ#)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I3CDEF$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE SYSTEM.LOGMNR_CCOL$ (
2 CON# NUMBER,
3 OBJ# NUMBER,
4 COL# NUMBER,
5 POS# NUMBER,
6 INTCOL# NUMBER NOT NULL,
7 logmnr_uid NUMBER(22),
8 logmnr_flags NUMBER(22),
9 constraint LOGMNR_CCOL$_pk
10 primary key (LOGMNR_UID, CON#, INTCOL#) disable )
11 PARTITION BY RANGE(logmnr_uid)
12 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
13 TABLESPACE SYSAUX LOGGING
14 /
CREATE TABLE SYSTEM.LOGMNR_CCOL$ (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I1CCOL$
2 ON SYSTEM.LOGMNR_CCOL$ (LOGMNR_UID, CON#, INTCOL#)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I1CCOL$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE SYSTEM.LOGMNR_ICOL$ (
2 OBJ# NUMBER,
3 BO# NUMBER,
4 COL# NUMBER,
5 POS# NUMBER,
6 SEGCOL# NUMBER,
7 INTCOL# NUMBER NOT NULL,
8 logmnr_uid NUMBER(22),
9 logmnr_flags NUMBER(22),
10 constraint LOGMNR_ICOL$_pk
11 primary key (LOGMNR_UID, OBJ#, INTCOL#) disable )
12 PARTITION BY RANGE(logmnr_uid)
13 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
14 TABLESPACE SYSAUX LOGGING
15 /
CREATE TABLE SYSTEM.LOGMNR_ICOL$ (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I1ICOL$
2 ON SYSTEM.LOGMNR_ICOL$ (LOGMNR_UID, OBJ#, INTCOL#)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I1ICOL$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE SYSTEM.LOGMNR_LOBFRAG$ (
2 FRAGOBJ# NUMBER,
3 PARENTOBJ# NUMBER,
4 TABFRAGOBJ# NUMBER,
5 INDFRAGOBJ# NUMBER,
6 FRAG# NUMBER NOT NULL,
7 logmnr_uid NUMBER(22),
8 logmnr_flags NUMBER(22),
9 constraint LOGMNR_LOBFRAG$_pk
10 primary key (LOGMNR_UID, FRAGOBJ#) disable )
11 PARTITION BY RANGE(logmnr_uid)
12 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
13 TABLESPACE SYSAUX LOGGING
14 /
CREATE TABLE SYSTEM.LOGMNR_LOBFRAG$ (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I1LOBFRAG$
2 ON SYSTEM.LOGMNR_LOBFRAG$ (LOGMNR_UID, FRAGOBJ#)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I1LOBFRAG$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE SYSTEM.LOGMNR_INDPART$ (
2 OBJ# NUMBER,
3 BO# NUMBER,
4 PART# NUMBER,
5 TS# NUMBER NOT NULL,
6 logmnr_uid NUMBER(22),
7 logmnr_flags NUMBER(22),
8 constraint LOGMNR_INDPART$_pk
9 primary key (LOGMNR_UID, OBJ#, BO#) disable )
10 PARTITION BY RANGE(logmnr_uid)
11 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
12 TABLESPACE SYSAUX LOGGING
13 /
CREATE TABLE SYSTEM.LOGMNR_INDPART$ (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I1INDPART$
2 ON SYSTEM.LOGMNR_INDPART$ (LOGMNR_UID, OBJ#, BO#)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I1INDPART$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I2INDPART$
2 ON SYSTEM.LOGMNR_INDPART$ (logmnr_uid, bo#)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I2INDPART$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE SYSTEM.LOGMNR_INDSUBPART$ (
2 OBJ# NUMBER(22),
3 DATAOBJ# NUMBER(22),
4 POBJ# NUMBER(22),
5 SUBPART# NUMBER(22),
6 TS# NUMBER(22) NOT NULL,
7 logmnr_uid NUMBER(22),
8 logmnr_flags NUMBER(22),
9 constraint LOGMNR_INDSUBPART$_pk
10 primary key (LOGMNR_UID, OBJ#, POBJ#) disable )
11 PARTITION BY RANGE(logmnr_uid)
12 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
13 TABLESPACE SYSAUX LOGGING
14 /
CREATE TABLE SYSTEM.LOGMNR_INDSUBPART$ (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I1INDSUBPART$
2 ON SYSTEM.LOGMNR_INDSUBPART$ (LOGMNR_UID, OBJ#, POBJ#)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I1INDSUBPART$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE SYSTEM.LOGMNR_INDCOMPART$ (
2 OBJ# NUMBER,
3 DATAOBJ# NUMBER,
4 BO# NUMBER,
5 PART# NUMBER NOT NULL,
6 logmnr_uid NUMBER(22),
7 logmnr_flags NUMBER(22),
8 constraint LOGMNR_INDCOMPART$_pk
9 primary key (LOGMNR_UID, OBJ#) disable )
10 PARTITION BY RANGE(logmnr_uid)
11 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
12 TABLESPACE SYSAUX LOGGING
13 /
CREATE TABLE SYSTEM.LOGMNR_INDCOMPART$ (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I1INDCOMPART$
2 ON SYSTEM.LOGMNR_INDCOMPART$ (LOGMNR_UID, OBJ#)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I1INDCOMPART$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE SYSTEM.LOGMNR_LOGMNR_BUILDLOG (
2 BUILD_DATE VARCHAR2(20),
3 DB_TXN_SCNBAS NUMBER,
4 DB_TXN_SCNWRP NUMBER,
5 CURRENT_BUILD_STATE NUMBER,
6 COMPLETION_STATUS NUMBER,
7 MARKED_LOG_FILE_LOW_SCN NUMBER,
8 INITIAL_XID VARCHAR2(22) NOT NULL,
9 logmnr_uid NUMBER(22),
10 logmnr_flags NUMBER(22),
11 constraint LOGMNR_LOGMNR_BUILDLOG_pk
12 primary key (LOGMNR_UID, INITIAL_XID) disable )
13 PARTITION BY RANGE(logmnr_uid)
14 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
15 TABLESPACE SYSAUX LOGGING
16 /
CREATE TABLE SYSTEM.LOGMNR_LOGMNR_BUILDLOG (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I1LOGMNR_BUILDLOG
2 ON SYSTEM.LOGMNR_LOGMNR_BUILDLOG (LOGMNR_UID, INITIAL_XID)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I1LOGMNR_BUILDLOG
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE SYSTEM.LOGMNR_NTAB$ (
2 col# number,
3 intcol# number,
4 ntab# number,
5 name varchar2(4000),
6 obj# number not null,
7 logmnr_uid NUMBER(22),
8 logmnr_flags NUMBER(22),
9 constraint LOGMNR_NTAB$_pk
10 primary key (LOGMNR_UID, OBJ#, INTCOL#) disable )
11 PARTITION BY RANGE(logmnr_uid)
12 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
13 TABLESPACE SYSAUX LOGGING
14 /
CREATE TABLE SYSTEM.LOGMNR_NTAB$ (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I1NTAB$
2 ON SYSTEM.LOGMNR_NTAB$ (LOGMNR_UID, OBJ#, INTCOL#)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I1NTAB$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I2NTAB$
2 ON SYSTEM.LOGMNR_NTAB$ (logmnr_uid, ntab#)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I2NTAB$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE SYSTEM.LOGMNR_OPQTYPE$ (
2 intcol# number not null,
3 type number,
4 flags number,
5 lobcol number,
6 objcol number,
7 extracol number,
8 schemaoid raw(16),
9 elemnum number,
10 schemaurl varchar2(4000),
11 obj# number not null,
12 logmnr_uid NUMBER(22),
13 logmnr_flags NUMBER(22),
14 constraint LOGMNR_OPQTYPE$_pk
15 primary key (LOGMNR_UID, OBJ#, INTCOL#) disable )
16 PARTITION BY RANGE(logmnr_uid)
17 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
18 TABLESPACE SYSAUX LOGGING
19 /
CREATE TABLE SYSTEM.LOGMNR_OPQTYPE$ (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I1OPQTYPE$
2 ON SYSTEM.LOGMNR_OPQTYPE$ (LOGMNR_UID, OBJ#, INTCOL#)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I1OPQTYPE$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE SYSTEM.LOGMNR_SUBCOLTYPE$ (
2 intcol# number not null,
3 toid raw(16) not null,
4 version# number not null,
5 intcols number,
6 intcol#s raw(2000),
7 flags number,
8 synobj# number,
9 obj# number not null,
10 logmnr_uid NUMBER(22),
11 logmnr_flags NUMBER(22),
12 constraint LOGMNR_SUBCOLTYPE$_pk
13 primary key (LOGMNR_UID, OBJ#, INTCOL#, TOID) disable )
14 PARTITION BY RANGE(logmnr_uid)
15 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
16 TABLESPACE SYSAUX LOGGING
17 /
CREATE TABLE SYSTEM.LOGMNR_SUBCOLTYPE$ (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I1SUBCOLTYPE$
2 ON SYSTEM.LOGMNR_SUBCOLTYPE$ (LOGMNR_UID, OBJ#, INTCOL#, TOID)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I1SUBCOLTYPE$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE SYSTEM.LOGMNR_KOPM$ (
2 length number,
3 metadata raw(255),
4 name varchar2(30) not null,
5 logmnr_uid NUMBER(22),
6 logmnr_flags NUMBER(22),
7 constraint LOGMNR_KOPM$_pk
8 primary key (LOGMNR_UID, NAME) disable )
9 PARTITION BY RANGE(logmnr_uid)
10 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
11 TABLESPACE SYSAUX LOGGING
12 /
CREATE TABLE SYSTEM.LOGMNR_KOPM$ (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I1KOPM$
2 ON SYSTEM.LOGMNR_KOPM$ (LOGMNR_UID, NAME)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I1KOPM$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE TABLE SYSTEM.LOGMNR_PROPS$ (
2 value$ varchar2(4000),
3 comment$ varchar2(4000),
4 name varchar2(30) not null,
5 logmnr_uid NUMBER(22),
6 logmnr_flags NUMBER(22),
7 constraint LOGMNR_PROPS$_pk
8 primary key (LOGMNR_UID, NAME) disable )
9 PARTITION BY RANGE(logmnr_uid)
10 ( PARTITION p_lessthan100 VALUES LESS THAN (100))
11 TABLESPACE SYSAUX LOGGING
12 /
CREATE TABLE SYSTEM.LOGMNR_PROPS$ (
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
CREATE INDEX SYSTEM.LOGMNR_I1PROPS$
2 ON SYSTEM.LOGMNR_PROPS$ (LOGMNR_UID, NAME)
3 TABLESPACE SYSAUX LOCAL LOGGING
4 /
CREATE INDEX SYSTEM.LOGMNR_I1PROPS$
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
Hello Kumar.
Please download the Database Upgrade Guide Upgrade to Oracle Database 11 Release 2 (11.2): Windows Based on Oracle Patch Set Release 11.2.0.4 available in http//:service.sap.com and follow the steps for this guide.
Execute one full backup of database before the upgrade.
Regards.
Desirée
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.