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