cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

BW 3.5 Unicode Conv. - DDL Statements larger than 64KB

Go to solution
Former Member

on ‎03-18-2008 4:50 PM

0 Kudos

Hey there,

I am trying a unicode conversion of an BW 3.5 SP 21 and executed the report SMIGR_CREATE_DDL. In Note 771209 there is a hint, that statements should not be larger than 64KB. I have let compressed the related tables but nothing has happened, they are still larger than 64KB


DDL GENERATOR FÜR DIE SAP SYSTEM MIGRATION                                                                                
/BIC/FYCP_COPDE : Die Größe des DDL Statements beträgt 81 KB     
/BI0/F0IC_C03 : Die Größe des DDL Statements beträgt 103 KB      
/BIC/FYCP_EKC : Die Größe des DDL Statements beträgt 139 KB      
DDL Statements wurden erfolgreich generiert                                                                                
(Size is 81/103/139KB - DDL Statements have been generated successfully)

I haven't tried any further step, as there is a warning, that import will fail if these statements are larger than 64KB.

Thanks in advance!

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
‎03-19-2008 4:04 PM
0 Kudos

Hi again

I just used /BI0/F0BWTC_C02 only as example, but i assume you have a the same issue on the other (/BIC/FYCP_COPDE, /BI0/F0IC_C03, /BIC/FYCP_EKC).

I am only a dba/basis guy, but i thought with compressing the requests the data will be put into the e-fact table and the partition in the f-table will be dropped. Are the partitions in the f-table emtpy?

Regards Michael

Show replies
Show replies
Former Member
‎03-19-2008 4:08 PM
0 Kudos

Hi there,

To be honest, I thought the same way and I have been told, that the compression has been succeeded. It is strange to me that I still get that message about the large tables.

How can I see whether these partitions in the f-table are empty?

Former Member
‎03-20-2008 7:14 AM
0 Kudos 
How can I see whether these partitions in the f-table are empty?

If you have sqlplus, information about partitions can be found in dba_tab_partitions, for example the partitions name:


SQL> select partition_name from dba_tab_partitions
     where table_name = '/BI0/F0BWTC_C02';
PARTITION_NAME
------------------------------
/BI0/F0BWTC_C020
/BI0/F0BWTC_C020000000003
/BI0/F0BWTC_C020000000004
/BI0/F0BWTC_C020000000005

How many rows does a specific partition have:


SQL> select count(*) from sapsr3."/BI0/F0BWTC_C02"
     partition("/BI0/F0BWTC_C020000000003");
  COUNT(*)
----------
     11057

Regards Michael

Former Member
‎03-20-2008 7:31 AM
0 Kudos

update:

to see the number of partitions:


SQL> select count(*) from dba_tab_partitions where  table_name = '/BI0/F0BWTC_C02';
  COUNT(*)
----------
         4

BTW: please have a look at SAP note 1010854 - Tables with too many partitions on MS SQL Server 2005.

Regards Michael

Former Member
‎03-20-2008 10:05 AM
0 Kudos

Hi again,


Using
"select partition_name from dba_tab_partitions where table_name = '(1) / (2) / (3)';

(1) - /BIC/FYCP_COPDE: Result - 746 rows
(2) - /BI0/F0IC_C03 : Result - 937 rows
(3) - /BIC/FYCP_EKC : Result 1241 rows

Using
"select count(*) from sapsr3."/BIC/FYCP_EKC" partition("/BIC/FYCP_EKC0000001537");
"select count(*) from sapsr3."/BIC/FYCP_EKC" partition("/BIC/FYCP_EKC0000001536");

only for testing resulted in 0 rows both.

Unfortunatley, Note 1010854 does not have a relation to my problem, as the compression succeeded with no errors.

Former Member
‎03-20-2008 11:58 AM
0 Kudos

Ok, we know so far:

- the SQL are to large because of too many partitions, which seem to be empty already

- compression of requests was made, but the partitions are still here

As i said before, i am not a BI expert, but here is what i can see:

- In the joblog of a compression job, you might be able to see a drop partition. You can see the joblogs either directly in SM37 or throught the BI transactions RSA1/RSMO. Here is a sample:


Datum      Uhrzeit  Nachrichtentext
20.03.2008 05:23:10 Job wurde gestartet
20.03.2008 05:23:10 Step 001 gestartet (Programm RSCOMP1, Variante &0000000005974, Benutzername USER1
20.03.2008 05:23:17 Check und potentieller Update auf Status-Steuertabelle wird durchgeführt
20.03.2008 05:23:18 FB RSM1_CHECK_DM_GOT_REQUEST aufgerufen von PRG RSSM_PROCESS_COMPRESS; Zeile 000200
20.03.2008 05:23:18 Request '274,687'; DTA 'M_11S36D1'; Action 'C'; Mit Dialog 'X'
...
20.03.2008 05:24:03 SQL: 20.03.2008 05:24:03 USER1
20.03.2008 05:24:03 ALTER TABLE "/BIC/FM_11S36D1" DROP PARTITION
20.03.2008 05:24:03 "/BIC/FM_11S36D10000001266"
20.03.2008 05:24:05 SQL-END: 20.03.2008 05:24:05 00:00:02
20.03.2008 05:24:05 SQL: 20.03.2008 05:24:05 USER1
20.03.2008 05:24:05 ALTER TABLE "/BIC/FM_11S36D1" DROP PARTITION
20.03.2008 05:24:05 "/BIC/FM_11S36D10000001264"
20.03.2008 05:24:06 SQL-END: 20.03.2008 05:24:06 00:00:01

Can you see a drop partition in your compression job logs?

Regards

Michael

Former Member
‎03-20-2008 12:17 PM
0 Kudos

What is the job name I have to look for?

There are plenty of jobs in that period so I am forced to filter. I already run jobname: RS* and user:* within a period where it had to be, but did not find anything. also I did not find jobname: COMPRESS.

Can there be a situation where no job has been executed, but the compression has been done directly?

Former Member
‎03-20-2008 12:21 PM
0 Kudos

I have BI_COMP* as names - Regards Michael

Former Member
‎03-20-2008 12:27 PM
0 Kudos

Okay, that's interesting...

I haven't found any BI_COMP* for the whole march. Neither non-periodic jobs assigning something similar. I think I will ask them what they have done exactly.

According to RSA1/RSMO - where can I find entries of the last actions or maybe compression actions? I haven't found a log-entry in the menue

Former Member
‎04-04-2008 10:39 AM
0 Kudos

Finally, I found a report that brings a solution.

SAP_DROP_EMPTY_FPARTITIONS / Note 590370

The Table with 1241 Partitions was empty. All partitions size had been 64KB. By using this report it removes all unnecessary partitions.

Answers (1)

Answers (1)

Former Member
‎03-19-2008 3:05 PM
0 Kudos

Hi Michael

Could you please investigate, how the statements look like. The only thing i can imagine is, that you have hundreds of partitions on these fact tables.

I executed the SMIGR_CREATE_DDL on one of our systems. I did not get such large statements...

Here is a sample, maybe yours look fundamentally different:


tab: /BI0/F0BWTC_C02
sql:    CREATE TABLE "/BI0/F0BWTC_C02"
      ("KEY_0BWTC_C02P" NUMBER (000010)
        DEFAULT 0 NOT NULL,
       "KEY_0BWTC_C02T" NUMBER (000010)
        DEFAULT 0 NOT NULL,

... cut some 50 columns here ...

       "TCTTOLAP" FLOAT
        DEFAULT 0 NOT NULL,
       "/BIC/M_IOCNTTC" NUMBER (000017, 000003)
        DEFAULT 0 NOT NULL)
      PCTFREE 10
      PCTUSED 60
      INITRANS 001
      TABLESPACE &USER2&
      STORAGE (INITIAL     0000000016 K
               NEXT        0000000016 K
               MINEXTENTS  0000000001
               MAXEXTENTS  2147483645
               PCTINCREASE 0000
               FREELISTS   004
               FREELIST GROUPS 01)
         PARTITION BY RANGE ("KEY_0BWTC_C02P")
         (
     PARTITION "/BI0/F0BWTC_C020" VALUES LESS THAN
     (0)
     TABLESPACE "&USER2&",
     PARTITION "/BI0/F0BWTC_C020000000003" VALUES LESS THAN
     (0000000003)
     TABLESPACE "&USER2&",
     PARTITION "/BI0/F0BWTC_C020000000004" VALUES LESS THAN
     (0000000004)
     TABLESPACE "&USER2&",
     PARTITION "/BI0/F0BWTC_C020000000005" VALUES LESS THAN
     (0000000005)
     TABLESPACE "&USER2&") ;

Regards, Michael

Show replies
Show replies
Former Member
‎03-19-2008 3:18 PM
0 Kudos

Hi Michael,

Well, i was looking for the same table .. I have much more partitions than you So, concerning this, you are quite right. But that was almost clear at the beginning - that is why I had to compress the Facttables. Unfortunately there was no change ...

Is there a reason for having taken this tab? Or just to show the size?


tab: /BI0/F0BWTC_C02
sql:    CREATE TABLE "/BI0/F0BWTC_C02"
      ("KEY_0BWTC_C02P" NUMBER (000010)
        DEFAULT 0 NOT NULL,
       "KEY_0BWTC_C02T" NUMBER (000010)
        DEFAULT 0 NOT NULL,
       "KEY_0BWTC_C02U" NUMBER (000010)
        DEFAULT 0 NOT NULL,
       "KEY_0BWTC_C021" NUMBER (000010)
        DEFAULT 0 NOT NULL,
       "KEY_0BWTC_C022" NUMBER (000010)
        DEFAULT 0 NOT NULL,
       "KEY_0BWTC_C023" NUMBER (000010)
        DEFAULT 0 NOT NULL,
       "KEY_0BWTC_C024" NUMBER (000010)
        DEFAULT 0 NOT NULL,
       "TCTSDATE" VARCHAR2 (000024)
        DEFAULT '00000000' NOT NULL,
       "TCTSTAUIK" NUMBER (000017, 000003)
        DEFAULT 0 NOT NULL,
       "TCTSTIMEK" VARCHAR2 (000018)
        DEFAULT '000000' NOT NULL,
       "TCTDBSCTR" NUMBER (000017, 000003)
        DEFAULT 0 NOT NULL,
       "TCTNAVCTR" NUMBER (000017, 000003)
        DEFAULT 0 NOT NULL,
       "TCTSESCTR" NUMBER (000017, 000003)
        DEFAULT 0 NOT NULL,
       "TCTCHAVRD" NUMBER (000017, 000003)
        DEFAULT 0 NOT NULL,
       "TCTNCELLS" NUMBER (000017, 000003)
        DEFAULT 0 NOT NULL,
       "TCTNDBSEL" NUMBER (000017, 000003)
        DEFAULT 0 NOT NULL,
       "TCTNDBTRA" NUMBER (000017, 000003)
        DEFAULT 0 NOT NULL,
       "TCTNODBOBS" NUMBER (000017, 000003)
        DEFAULT 0 NOT NULL,
       "TCTNODBOCA" NUMBER (000017, 000003)
        DEFAULT 0 NOT NULL,
       "TCTNOLAPAL" NUMBER (000017, 000003)
        DEFAULT 0 NOT NULL,
       "TCTNOLARD" NUMBER (000017, 000003)
        DEFAULT 0 NOT NULL,
       "TCTNRANGS" NUMBER (000017, 000003)
        DEFAULT 0 NOT NULL,
       "TCTNTEXTS" NUMBER (000017, 000003)
        DEFAULT 0 NOT NULL,
       "TCTTAUTH" FLOAT
        DEFAULT 0 NOT NULL,
       "TCTTDBRD" FLOAT
        DEFAULT 0 NOT NULL,
       "TCTTDMCACC" FLOAT
        DEFAULT 0 NOT NULL,
       "TCTTDMDBB" FLOAT
        DEFAULT 0 NOT NULL,
       "TCTTDMDBO" FLOAT
        DEFAULT 0 NOT NULL,
       "TCTTDMDBR" FLOAT
        DEFAULT 0 NOT NULL,
       "TCTTDMNCUM" FLOAT
        DEFAULT 0 NOT NULL,
       "TCTTDMRSID" FLOAT
        DEFAULT 0 NOT NULL,
       "TCTTFRONT" FLOAT
        DEFAULT 0 NOT NULL,
       "TCTTNAVIG" FLOAT
        DEFAULT 0 NOT NULL,
       "TCTTODBOAL" FLOAT
        DEFAULT 0 NOT NULL,
       "TCTTODBOAX" FLOAT
        DEFAULT 0 NOT NULL,
       "TCTTODBODA" FLOAT
        DEFAULT 0 NOT NULL,
       "TCTTODBOFL" FLOAT
        DEFAULT 0 NOT NULL,
       "TCTTODBOIN" FLOAT
        DEFAULT 0 NOT NULL,
       "TCTTODBORE" FLOAT
        DEFAULT 0 NOT NULL,
       "TCTTOLAPAL" FLOAT
        DEFAULT 0 NOT NULL,
       "TCTTOLINI" FLOAT
        DEFAULT 0 NOT NULL,
       "TCTTRDMDA" FLOAT
        DEFAULT 0 NOT NULL,
       "TCTTREST" FLOAT
        DEFAULT 0 NOT NULL,
       "TCTTVARDP" FLOAT
        DEFAULT 0 NOT NULL,
       "TCTTOLAP" FLOAT
        DEFAULT 0 NOT NULL)
      PCTFREE 10
      PCTUSED 60
      INITRANS 001
      TABLESPACE &APPL0&
      STORAGE (INITIAL     0000000016 K
               NEXT        0000000016 K
               MINEXTENTS  0000000001
               MAXEXTENTS  2147483645
               PCTINCREASE 0000
               FREELISTS   004
               FREELIST GROUPS 01)
         PARTITION BY RANGE ("KEY_0BWTC_C02P")
         (
     PARTITION "/BI0/F0BWTC_C020" VALUES LESS THAN
     (0)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000005" VALUES LESS THAN
     (0000000005)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000006" VALUES LESS THAN
     (0000000006)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000008" VALUES LESS THAN
     (0000000008)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000009" VALUES LESS THAN
     (0000000009)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000010" VALUES LESS THAN
     (0000000010)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000011" VALUES LESS THAN
     (0000000011)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000012" VALUES LESS THAN
     (0000000012)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000013" VALUES LESS THAN
     (0000000013)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000014" VALUES LESS THAN
     (0000000014)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000015" VALUES LESS THAN
     (0000000015)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000016" VALUES LESS THAN
     (0000000016)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000017" VALUES LESS THAN
     (0000000017)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000018" VALUES LESS THAN
     (0000000018)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000019" VALUES LESS THAN
     (0000000019)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000020" VALUES LESS THAN
     (0000000020)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000021" VALUES LESS THAN
     (0000000021)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000022" VALUES LESS THAN
     (0000000022)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000023" VALUES LESS THAN
     (0000000023)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000024" VALUES LESS THAN
     (0000000024)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000025" VALUES LESS THAN
     (0000000025)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000026" VALUES LESS THAN
     (0000000026)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000027" VALUES LESS THAN
     (0000000027)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000028" VALUES LESS THAN
     (0000000028)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000029" VALUES LESS THAN
     (0000000029)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000030" VALUES LESS THAN
     (0000000030)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000031" VALUES LESS THAN
     (0000000031)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000032" VALUES LESS THAN
     (0000000032)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000033" VALUES LESS THAN
     (0000000033)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000034" VALUES LESS THAN
     (0000000034)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000035" VALUES LESS THAN
     (0000000035)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000036" VALUES LESS THAN
     (0000000036)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000037" VALUES LESS THAN
     (0000000037)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000038" VALUES LESS THAN
     (0000000038)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000039" VALUES LESS THAN
     (0000000039)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000040" VALUES LESS THAN
     (0000000040)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000041" VALUES LESS THAN
     (0000000041)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000042" VALUES LESS THAN
     (0000000042)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000043" VALUES LESS THAN
     (0000000043)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000044" VALUES LESS THAN
     (0000000044)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000045" VALUES LESS THAN
     (0000000045)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000046" VALUES LESS THAN
     (0000000046)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000047" VALUES LESS THAN
     (0000000047)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000048" VALUES LESS THAN
     (0000000048)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000049" VALUES LESS THAN
     (0000000049)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000050" VALUES LESS THAN
     (0000000050)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000051" VALUES LESS THAN
     (0000000051)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000052" VALUES LESS THAN
     (0000000052)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000053" VALUES LESS THAN
     (0000000053)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000054" VALUES LESS THAN
     (0000000054)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000055" VALUES LESS THAN
     (0000000055)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000056" VALUES LESS THAN
     (0000000056)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000057" VALUES LESS THAN
     (0000000057)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000058" VALUES LESS THAN
     (0000000058)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000059" VALUES LESS THAN
     (0000000059)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000060" VALUES LESS THAN
     (0000000060)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000061" VALUES LESS THAN
     (0000000061)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000062" VALUES LESS THAN
     (0000000062)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000063" VALUES LESS THAN
     (0000000063)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000064" VALUES LESS THAN
     (0000000064)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000065" VALUES LESS THAN
     (0000000065)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000066" VALUES LESS THAN
     (0000000066)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000067" VALUES LESS THAN
     (0000000067)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000068" VALUES LESS THAN
     (0000000068)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000069" VALUES LESS THAN
     (0000000069)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000070" VALUES LESS THAN
     (0000000070)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000071" VALUES LESS THAN
     (0000000071)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000072" VALUES LESS THAN
     (0000000072)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000073" VALUES LESS THAN
     (0000000073)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000074" VALUES LESS THAN
     (0000000074)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000075" VALUES LESS THAN
     (0000000075)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000076" VALUES LESS THAN
     (0000000076)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000077" VALUES LESS THAN
     (0000000077)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000078" VALUES LESS THAN
     (0000000078)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000079" VALUES LESS THAN
     (0000000079)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000080" VALUES LESS THAN
     (0000000080)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000081" VALUES LESS THAN
     (0000000081)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000082" VALUES LESS THAN
     (0000000082)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000083" VALUES LESS THAN
     (0000000083)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000084" VALUES LESS THAN
     (0000000084)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000085" VALUES LESS THAN
     (0000000085)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000086" VALUES LESS THAN
     (0000000086)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000087" VALUES LESS THAN
     (0000000087)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000088" VALUES LESS THAN
     (0000000088)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000089" VALUES LESS THAN
     (0000000089)
     TABLESPACE "&APPL0&",
     PARTITION "/BI0/F0BWTC_C020000000090" VALUES LESS THAN
     (0000000090)
     TABLESPACE "&APPL0&") ;

Regards,

Michael

Ask a Question