Skip to Content
0
May 06, 2008 at 08:58 PM

Brspace error

98 Views

I did a :

brspace -f tbreorg -a reorg -i psapods2i -m offline -n psapods2d -s psapodsd -t "*"

then a:

brspace -f tbreorg -a reorg -i psapodsi -m offline -n psapodsd -s psapods2d -t "*"

Now dataloads are failing. They are trying to create things in PSAPODS2I which does not exist any more. When I created the DDL for one of the failing loads I get the following. Notice the PSAPODS2I at the end? Where is that stored? I have looked ALL over SAP/Oracle..

Oracle 10.2.0.2 on HP-UX Itanium 64

BRSPACE is version 33.

Thanks-

Vince

CREATE UNIQUE INDEX "SAPR3"."/BIC/B0000282000~0" ON

"SAPR3"."/BIC/B0000282000"

("REQUEST", "DATAPAKID", "PARTNO", "RECORD")

LOCAL

(

PARTITION "/BIC/B00002820000000000002"

STORAGE (

INITIAL 16384

NEXT 65536

MAXEXTENTS UNLIMITED

PCTINCREASE 0

FREELISTS 1

FREELIST GROUPS 1

)

PCTFREE 10

INITRANS 2

MAXTRANS 255

TABLESPACE "PSAPODSI"

LOGGING,

PARTITION "/BIC/B00002820000000000003"

STORAGE (

INITIAL 16384

NEXT 65536

MAXEXTENTS UNLIMITED

PCTINCREASE 0

FREELISTS 1

FREELIST GROUPS 1

)

PCTFREE 10

INITRANS 2

MAXTRANS 255

TABLESPACE "PSAPODSI"

LOGGING,

PARTITION "/BIC/B00002820000000000004"

STORAGE (

INITIAL 16384

NEXT 65536

MAXEXTENTS UNLIMITED

PCTINCREASE 0

FREELISTS 1

FREELIST GROUPS 1

)

PCTFREE 10

INITRANS 2

MAXTRANS 255

TABLESPACE "PSAPODSI"

LOGGING,

PARTITION "/BIC/B00002820000000000005"

STORAGE (

INITIAL 16384

NEXT 65536

MAXEXTENTS UNLIMITED

PCTINCREASE 0

FREELISTS 1

FREELIST GROUPS 1

)

PCTFREE 10

INITRANS 2

MAXTRANS 255

TABLESPACE "PSAPODSI"

LOGGING,

PARTITION "/BIC/B00002820000000000006"

STORAGE (

INITIAL 16384

NEXT 65536

MAXEXTENTS UNLIMITED

PCTINCREASE 0

FREELISTS 1

FREELIST GROUPS 1

)

PCTFREE 10

INITRANS 2

MAXTRANS 255

TABLESPACE "PSAPODSI"

LOGGING,

PARTITION "/BIC/B00002820000000000008"

STORAGE (

INITIAL 16384

NEXT 65536

MAXEXTENTS UNLIMITED

PCTINCREASE 0

FREELISTS 1

FREELIST GROUPS 1

)

PCTFREE 10

INITRANS 2

MAXTRANS 255

TABLESPACE "PSAPODSI"

LOGGING,

PARTITION "/BIC/B00002820000000000010"

STORAGE (

INITIAL 16384

NEXT 65536

MAXEXTENTS UNLIMITED

PCTINCREASE 0

FREELISTS 1

FREELIST GROUPS 1

)

PCTFREE 10

INITRANS 2

MAXTRANS 255

TABLESPACE "PSAPODSI"

LOGGING,

PARTITION "/BIC/B00002820000000000011"

STORAGE (

INITIAL 16384

NEXT 65536

MAXEXTENTS UNLIMITED

PCTINCREASE 0

FREELISTS 1

FREELIST GROUPS 1

)

PCTFREE 10

INITRANS 2

MAXTRANS 255

TABLESPACE "PSAPODSI"

LOGGING,

PARTITION "/BIC/B00002820000000000012"

STORAGE (

INITIAL 16384

NEXT 65536

MAXEXTENTS UNLIMITED

PCTINCREASE 0

FREELISTS 1

FREELIST GROUPS 1

)

PCTFREE 10

INITRANS 2

MAXTRANS 255

TABLESPACE "PSAPODSI"

LOGGING,

PARTITION "/BIC/B00002820000000000013"

STORAGE (

INITIAL 16384

NEXT 65536

MAXEXTENTS UNLIMITED

PCTINCREASE 0

FREELISTS 1

FREELIST GROUPS 1

)

PCTFREE 10

INITRANS 2

MAXTRANS 255

TABLESPACE "PSAPODSI"

LOGGING,

PARTITION "/BIC/B00002820000000000014"

STORAGE (

INITIAL 16384

NEXT 65536

MAXEXTENTS UNLIMITED

PCTINCREASE 0

FREELISTS 1

FREELIST GROUPS 1

)

PCTFREE 10

INITRANS 2

MAXTRANS 255

TABLESPACE "PSAPODSI"

LOGGING,

PARTITION "/BIC/B00002820000000000015"

STORAGE (

INITIAL 16384

NEXT 65536

MAXEXTENTS UNLIMITED

PCTINCREASE 0

FREELISTS 1

FREELIST GROUPS 1

)

PCTFREE 10

INITRANS 2

MAXTRANS 255

TABLESPACE "PSAPODSI"

LOGGING,

PARTITION "/BIC/B00002820000000000016"

STORAGE (

INITIAL 16384

NEXT 65536

MAXEXTENTS UNLIMITED

PCTINCREASE 0

FREELISTS 1

FREELIST GROUPS 1

)

PCTFREE 10

INITRANS 2

MAXTRANS 255

TABLESPACE "PSAPODSI"

LOGGING,

PARTITION "/BIC/B00002820000000000017"

STORAGE (

INITIAL 16384

NEXT 65536

MAXEXTENTS UNLIMITED

PCTINCREASE 0

FREELISTS 1

FREELIST GROUPS 1

)

PCTFREE 10

INITRANS 2

MAXTRANS 255

TABLESPACE "PSAPODSI"

LOGGING

)

STORAGE (

INITIAL 2

NEXT 320

MAXEXTENTS 2147483645

PCTINCREASE 0

FREELISTS 1

)

PCTFREE 10

INITRANS 2

MAXTRANS 255

NOCOMPRESS

LOGGING

TABLESPACE "PSAPODS2I"

NOPARALLEL;

Edited by: Vince Laurent on May 6, 2008 11:27 PM