prikey: AFTER_LOAD
seckey: AFTER_LOAD
cretab: CREATE TABLE &tab_name&
( /{ &fld_name& &fld_desc& /-, /} )
TABLESPACE &tablespace&
&lob_cache&
STORAGE (INITIAL &init&
NEXT &next&
MINEXTENTS &minext&
MAXEXTENTS &maxext&
PCTINCREASE &pctinc& )
drptab: DROP TABLE &tab_name&
crepky: CREATE UNIQUE INDEX &pri_key&
ON &tab_name&
( &key_fld& /-, )
TABLESPACE &tablespace&
STORAGE (INITIAL &init&
NEXT &next&
MINEXTENTS &minext&
MAXEXTENTS &maxext&
PCTINCREASE &pctinc& )
NOLOGGING
COMPUTE STATISTICS
PARALLEL ;
ALTER INDEX &pri_key& LOGGING NOPARALLEL
drppky: DROP INDEX &pri_key&
creind: CREATE &unique& INDEX &ind_name&
ON &tab_name&
( /{ &fld_name& /-, /} )
TABLESPACE &tablespace&
STORAGE (INITIAL &init&
NEXT &next&
MINEXTENTS &minext&
MAXEXTENTS &maxext&
PCTINCREASE &pctinc& )
NOLOGGING
COMPUTE STATISTICS
PARALLEL ;
ALTER INDEX &ind_name& LOGGING NOPARALLEL
drpind: DROP INDEX &ind_name&
crevie: CREATE VIEW &view_name&
( /{ &fld_name& /-, /} )
AS &query&
drpvie: DROP VIEW &view_name&
trcdat: TRUNCATE TABLE &tab_name&
deldat: DELETE FROM &tab_name& &where&
negtab: LICHECK MLICHECK
negdat: LICHECK MLICHECK
negind: LICHECK~0 MLICHECK~0 LICHECK^0 MLICHECK^0
negvie:
# table storage parameters
loc: APPL0 PSAP@SCHEMAID@ 0000
APPL1 PSAP@SCHEMAID@ 0000
APPL2 PSAP@SCHEMAID@ 0000
CLUST PSAP@SCHEMAID@ 0000
DDIM PSAP@SCHEMAID@ 0000
DFACT PSAP@SCHEMAID@ 0000
DODS PSAP@SCHEMAID@ 0000
POOL PSAP@SCHEMAID@ 0000
SDIC PSAP@SCHEMAID@ 0000
SDOCU PSAP@SCHEMAID@ 0000
SLDEF PSAP@SCHEMAID@701 0000
SLEXC PSAP@SCHEMAID@701 0000
SLOAD PSAP@SCHEMAID@ 0000
SPROT PSAP@SCHEMAID@ 0000
SSDEF PSAP@SCHEMAID@701 0000
SSEXC PSAP@SCHEMAID@701 0000
SSRC PSAP@SCHEMAID@ 0000
TEMP PSAP@SCHEMAID@ 0000
USER PSAP@SCHEMAID@USR 0000
USER1 PSAP@SCHEMAID@USR 0000
sto: 0 0000000016K 0000000040K 0000000001 2147483645
1 0000000016K 0000000160K 0000000001 2147483645
10 0000000016K 0000655360K 0000000001 2147483645
11 0000000016K 0001310720K 0000000001 2147483645
12 0000000016K 0002621440K 0000000001 2147483645
13 0000000016K 0005242880K 0000000001 2147483645
14 0000000016K 0010485760K 0000000001 2147483645
2 0000000016K 0000000640K 0000000001 2147483645
3 0000000016K 0000002560K 0000000001 2147483645
4 0000000016K 0000010240K 0000000001 2147483645
5 0000000016K 0000020480K 0000000001 2147483645
6 0000000016K 0000040960K 0000000001 2147483645
7 0000000016K 0000081920K 0000000001 2147483645
8 0000000016K 0000163840K 0000000001 2147483645
9 0000000016K 0000327680K 0000000001 2147483645
# index storage parameters
loc: APPL0 PSAP@SCHEMAID@ 0000
APPL1 PSAP@SCHEMAID@ 0000
APPL2 PSAP@SCHEMAID@ 0000
CLUST PSAP@SCHEMAID@ 0000
DDIM PSAP@SCHEMAID@ 0000
DFACT PSAP@SCHEMAID@ 0000
DODS PSAP@SCHEMAID@ 0000
POOL PSAP@SCHEMAID@ 0000
SDIC PSAP@SCHEMAID@ 0000
SDOCU PSAP@SCHEMAID@ 0000
SLDEF PSAP@SCHEMAID@701 0000
SLEXC PSAP@SCHEMAID@701 0000
SLOAD PSAP@SCHEMAID@ 0000
SPROT PSAP@SCHEMAID@ 0000
SSDEF PSAP@SCHEMAID@701 0000
SSEXC PSAP@SCHEMAID@701 0000
SSRC PSAP@SCHEMAID@ 0000
TEMP PSAP@SCHEMAID@ 0000
USER PSAP@SCHEMAID@USR 0000
USER1 PSAP@SCHEMAID@USR 0000
sto: 0 0000000016K 0000000040K 0000000001 2147483645
1 0000000016K 0000000080K 0000000001 2147483645
10 0000000016K 0000163840K 0000000001 2147483645
11 0000000016K 0000327680K 0000000001 2147483645
12 0000000016K 0000655360K 0000000001 2147483645
13 0000000016K 0001310720K 0000000001 2147483645
14 0000000016K 0002621440K 0000000001 2147483645
2 0000000016K 0000000160K 0000000001 2147483645
3 0000000016K 0000000640K 0000000001 2147483645
4 0000000016K 0000002560K 0000000001 2147483645
5 0000000016K 0000005120K 0000000001 2147483645
6 0000000016K 0000010240K 0000000001 2147483645
7 0000000016K 0000020480K 0000000001 2147483645
8 0000000016K 0000040960K 0000000001 2147483645
9 0000000016K 0000081920K 0000000001 2147483645
