Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Tablespace/Datafile Layout for Datawarehouse

Tablespace/Datafile Layout for Datawarehouse

From: Dereck L. Dietz <dietzdl_at_ameritech.net>
Date: Fri, 8 Jun 2007 22:08:57 -0500
Message-ID: <PYnai.11712$4Y.4042@newssvr19.news.prodigy.net> 





Oracle 10.2.0.3.0, 8 GB memory, Windows 2003 Server



Below is the layout of tablespaces and datafiles for the datawarehouse where
I work (the X's in the directory path are to protect the innocent/guilty).
In a previous post here it appears that the drives could be mount points.



Does the layout make sense?  Having so many tablespaces on the same
drive/mount points?



I'm questioning this because we've been experiencing disk utilization rates
of 98%+ on the F and G drives in the past few weeks.



Thanks.



1=Status, 2=Type, 3=Extent Management, 4=Allocation Type, 5=Segment Space
Management/Size (temp tablespaces only)


6=Enable Logging, 7=Block Size


                                                                           1
2        3             4         5                6       7
APP_DATA01                              140,000 MB RW PERM LOCAL AUTO MANUAL


YES 8192


 app_data01_1.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data01_2.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data01_3.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data01_4.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data01_5.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data01_6.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data01_7.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data01_8.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data01_9.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data01_10.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data01_11.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data01_12.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data01_13.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data01_14.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data01_15.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data01_16.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data01_17.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data01_18.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data01_19.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data01_20.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data01_21.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data01_22.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data01_23.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data01_24.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data01_25.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data01_26.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data01_27.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data01_28.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data01_29.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data01_30.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data01_31.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data01_32.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data01_33.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data01_34.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data01_35.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB

APP_DATA02                              140,000 MB RW PERM LOCAL AUTO MANUAL


YES 8192


 app_data02_1.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data02_2.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data02_3.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data02_4.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data02_5.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data02_6.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data02_7.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data02_8.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data02_9.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data02_10.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data02_11.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data02_12.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data02_13.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data02_14.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data02_15.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data02_16.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data02_17.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data02_18.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data02_19.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data02_20.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data02_21.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data02_22.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data02_23.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data02_24.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data02_25.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data02_26.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data02_27.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data02_28.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data02_29.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data02_30.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data02_31.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data02_32.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data02_33.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data02_34.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data02_35.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB

APP_DATA03                             140,000 MB RW PERM LOCAL AUTO MANUAL


YES 8192


 app_data03_1.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data03_2.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data03_3.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data03_4.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data03_5.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data03_6.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data03_7.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data03_8.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data03_9.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data03_10.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data03_11.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data03_12.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data03_13.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data03_14.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data03_15.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data03_16.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data03_17.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data03_18.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data03_19.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data03_20.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data03_21.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data03_22.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data03_23.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data03_24.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data03_25.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data03_26.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data03_27.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data03_28.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data03_29.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data03_30.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data03_31.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data03_32.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data03_33.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data03_34.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data03_35.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB

APP_DATA04                             140,000 MB RW PERM LOCAL AUTO MANUAL


YES 8192


 app_data04_1.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data04_2.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data04_3.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data04_4.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data04_5.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data04_6.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data04_7.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data04_8.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data04_9.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data04_10.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data04_11.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data04_12.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data04_13.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data04_14.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data04_15.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data04_16.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data04_17.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data04_18.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data04_19.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data04_20.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data04_21.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data04_22.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data04_23.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data04_24.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data04_25.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data04_26.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data04_27.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data04_28.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data04_29.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data04_30.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data04_31.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data04_32.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data04_33.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data04_34.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data04_35.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB

APP_DATA05                             140,000 MB RW PERM LOCAL AUTO MANUAL


YES 8192


 app_data05_1.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data05_2.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data05_3.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data05_4.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data05_5.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data05_6.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data05_7.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data05_8.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data05_9.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data05_10.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data05_11.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data05_12.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data05_13.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data05_14.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data05_15.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data05_16.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data05_17.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data05_18.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data05_19.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data05_20.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data05_21.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data05_22.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data05_23.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data05_24.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data05_25.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data05_26.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data05_27.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data05_28.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data05_29.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data05_30.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data05_31.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data05_32.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data05_33.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data05_34.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data05_35.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB

APP_DATA06                             140,000 MB RW PERM LOCAL AUTO MANUAL


YES 8192


 app_data06_1.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data06_2.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data06_3.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data06_4.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data06_5.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data06_6.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data06_7.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data06_8.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data06_9.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data06_10.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data06_11.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data06_12.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data06_13.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data06_14.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data06_15.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data06_16.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data06_17.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data06_18.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data06_19.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data06_20.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data06_21.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data06_22.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data06_23.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data06_24.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data06_25.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data06_26.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data06_27.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data06_28.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data06_29.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data06_30.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data06_31.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data06_32.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data06_33.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data06_34.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data06_35.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB

APP_DATA07                              140,000 MB RW PERM LOCAL AUTO MANUAL


YES 8192


 app_data07_1.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data07_2.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data07_3.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data07_4.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data07_5.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data07_6.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data07_7.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data07_8.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data07_9.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data07_10.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data07_11.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data07_12.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data07_13.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data07_14.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data07_15.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data07_16.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data07_17.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data07_18.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data07_19.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data07_20.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data07_21.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data07_22.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data07_23.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data07_24.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data07_25.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data07_26.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data07_27.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data07_28.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data07_29.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data07_30.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data07_31.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data07_32.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data07_33.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data07_34.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data07_35.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB

APP_DATA08                             140,000 MB RW PERM LOCAL AUTO MANUAL


YES 8192


 app_data08_1.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data08_2.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data08_3.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data08_4.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data08_5.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data08_6.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data08_7.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data08_8.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data08_9.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data08_10.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data08_11.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data08_12.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data08_13.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data08_14.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data08_15.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data08_16.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data08_17.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data08_18.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data08_19.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data08_20.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data08_21.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data08_22.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data08_23.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data08_24.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data08_25.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data08_26.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data08_27.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data08_28.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data08_29.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data08_30.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data08_31.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data08_32.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data08_33.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data08_34.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data08_35.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB

APP_DATA09                             140,000 MB RW PERM LOCAL AUTO AUTO


YES 8192


 app_data09_1.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data09_2.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data09_3.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data09_4.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data09_5.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data09_6.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data09_7.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data09_8.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data09_9.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data09_10.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data09_11.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data09_12.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data09_13.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data09_14.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data09_15.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data09_16.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data09_17.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data09_18.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data09_19.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data09_20.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data09_21.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data09_22.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data09_23.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data09_24.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data09_25.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data09_26.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data09_27.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data09_28.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data09_29.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data09_30.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data09_31.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data09_32.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data09_33.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data09_34.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data09_35.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB

APP_DATA10                             140,000 MB RW PERM LOCAL AUTO MANUAL


YES 8192


 app_data10_1.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_2.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_3.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_4.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_5.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_6.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_7.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_8.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_9.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_10.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_11.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_12.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_13.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_14.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_15.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_16.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_17.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_18.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_19.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_20.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_21.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_22.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_23.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_24.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_25.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_26.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_27.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_28.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_29.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_30.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_31.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_32.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_33.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_34.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_35.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB

APP_DATA11                             140,000 MB RW PERM LOCAL AUTO MANUAL


YES 8192


 app_data10_1.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_2.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_3.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_4.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_5.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_6.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_7.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_8.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_9.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_10.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_11.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_12.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_13.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_14.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_15.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_16.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_17.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_18.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_19.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_20.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_21.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_22.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_23.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_24.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_25.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_26.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_27.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_28.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_29.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_30.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_31.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_32.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_33.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_34.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data10_35.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB

APP_DATA12                             140,000 MB RW PERM LOCAL AUTO AUTO


YES 8192


 app_data12_1.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data12_2.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data12_3.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data12_4.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data12_5.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data12_6.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data12_7.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data12_8.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data12_9.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data12_10.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data12_11.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data12_12.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data12_13.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data12_14.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data12_15.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data12_16.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data12_17.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data12_18.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data12_19.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data12_20.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data12_21.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data12_22.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data12_23.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data12_24.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data12_25.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data12_26.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data12_27.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data12_28.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data12_29.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data12_30.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data12_31.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data12_32.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data12_33.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data12_34.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_data12_35.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB

APP_INDX01                              40,000 MB RW PERM LOCAL AUTO MANUAL


YES 8192


 app_indx01_1.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx01_2.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx01_3.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx01_4.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx01_5.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx01_6.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx01_7.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx01_8.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx01_9.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx01_10.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB

APP_INDX02                              40,000 MB RW PERM LOCAL AUTO AUTO


YES 8192


 app_indx02_1.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx02_2.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx02_3.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx02_4.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx02_5.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx02_6.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx02_7.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx02_8.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx02_9.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx02_10.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB

APP_INDX03                             40,000 MB RW PERM LOCAL AUTO AUTO


YES 8192


 app_indx03_1.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx03_2.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx03_3.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx03_4.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx03_5.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx03_6.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx03_7.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx03_8.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx03_9.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx03_10.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB

APP_INDX04                              40,000 MB RW PERM LOCAL AUTO MANUAL


YES 8192


 app_indx04_1.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx04_2.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx04_3.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx04_4.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx04_5.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx04_6.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx04_7.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx04_8.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx04_9.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx04_10.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB

APP_INDX05                              40,000 MB RW PERM LOCAL AUTO MANUAL


NO  8192

 app_indx05_1.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx05_2.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx05_3.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx05_4.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx05_5.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx05_6.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx05_7.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx05_8.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx05_9.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx05_10.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB

APP_INDX06                              40,000 MB RW PERM LOCAL AUTO MANUAL


YES 8192


 app_indx06_1.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx06_2.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx06_3.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx06_4.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx06_5.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx06_6.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx06_7.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx06_8.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx06_9.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx06_10.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB

APP_INDX07                              40,000 MB RW PERM LOCAL AUTO MANUAL


YES 8192


 app_indx07_1.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx07_2.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx07_3.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx07_4.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx07_5.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx07_6.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx07_7.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx07_8.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx07_9.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx07_10.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB

APP_INDX08                              40,000 MB RW PERM LOCAL AUTO MANUAL


YES 8192


 app_indx08_1.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx08_2.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx08_3.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx08_4.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx08_5.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx08_6.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx08_7.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx08_8.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx08_9.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx08_10.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB

APP_INDX09                              40,000 MB RW PERM LOCAL AUTO MANUAL


YES 8192


 app_indx09_1.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx09_2.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx09_3.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx09_4.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx09_5.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx09_6.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx09_7.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx09_8.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx09_9.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx09_10.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB

APP_INDX10                              40,000 MB RW PERM LOCAL AUTO MANUAL


YES 8192


 app_indx10_1.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx10_2.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx10_3.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx10_4.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx10_5.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx10_6.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx10_7.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx10_8.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx10_9.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx10_10.ora G:\ORACLE\ORADATA\XXXXXXX\   4,000 MB

APP_INDX11                              40,000 MB RW PERM LOCAL AUTO MANUAL


YES 8192


 app_indx11_1.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx11_2.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx11_3.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx11_4.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx11_5.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx11_6.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx11_7.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx11_8.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx11_9.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indx11_10.ora F:\ORACLE\ORADATA\XXXXXXX\   4,000 MB

APP_INDXCLM                              60,000 MB RW PERM LOCAL AUTO AUTO


YES 8192


 app_indxclm_1.ora D:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indxclm_2.ora D:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indxclm_3.ora D:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indxclm_4.ora D:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indxclm_5.ora D:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indxclm_6.ora D:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indxclm_7.ora D:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indxclm_8.ora D:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indxclm_9.ora D:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indxclm_10.ora D:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indxclm_11.ora D:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indxclm_12.ora D:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indxclm_13.ora D:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indxclm_14.ora D:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_indxclm_15.ora D:\ORACLE\ORADATA\XXXXXXX\   4,000 MB

APP_TEMP                             140,000 MB RW PERM LOCAL AUTO AUTO


YES 8192


 app_temp_1.ora  E:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_temp_2.ora  E:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_temp_3.ora  E:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_temp_4.ora  E:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_temp_5.ora  E:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_temp_6.ora  E:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_temp_7.ora  E:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_temp_8.ora  E:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_temp_9.ora  E:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_temp_10.ora  E:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_temp_11.ora  E:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_temp_12.ora  E:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_temp_13.ora  E:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_temp_14.ora  E:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_temp_15.ora  E:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_temp_16.ora  E:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_temp_17.ora  E:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_temp_18.ora  E:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_temp_19.ora  E:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_temp_20.ora  E:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_temp_21.ora  E:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_temp_22.ora  E:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_temp_23.ora  E:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_temp_24.ora  E:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_temp_25.ora  E:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_temp_26.ora  E:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_temp_27.ora  E:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_temp_28.ora  E:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_temp_29.ora  E:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_temp_30.ora  E:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_temp_31.ora  E:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_temp_32.ora  E:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_temp_33.ora  E:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_temp_34.ora  E:\ORACLE\ORADATA\XXXXXXX\   4,000 MB
 app_temp_35.ora  E:\ORACLE\ORADATA\XXXXXXX\   4,000 MB

SYSAUX                                2,000 MB RW PERM LOCAL AUTO AUTO   YES


8192


 sysaux01.dbf  E:\ORACLE\ORADATA\XXXXXXX\   2,000 MB


SYSTEM                               28,740 MB RW PERM LOCAL AUTO MANUAL YES


8192


 system01.dbf  E:\ORACLE\ORADATA\XXXXXXX\  28,740 MB


TEMP                               57,768 MB RW TEMP LOCAL UNIFORM 1024 NO


8192


 temp01.dbf  E:\ORACLE\ORADATA\XXXXXXX\  32,767 MB
 temp01_2.dbf  E:\ORACLE\ORADATA\XXXXXXX\  25,000 MB


TEMP_02                               50,000 MB RW TEMP LOCAL UNIFORM 1024


NO 8192


 temp_02_1.ora  E:\ORACLE\ORADATA\XXXXXXX\  25,000 MB
 temp_02_2.ora  E:\ORACLE\ORADATA\XXXXXXX\  25,000 MB


TEMP_03                               57,767 MB RW TEMP LOCAL UNIFORM 1024


NO 8192


 temp_03.ora  G:\ORACLE\ORADATA\XXXXXXX\  32,767 MB
 temp_03_2.ora  G:\ORACLE\ORADATA\XXXXXXX\  25,000 MB


TEMP_04                               57,767 MB RW TEMP LOCAL UNIFORM 1024


NO 8192


 temp_04.ora  G:\ORACLE\ORADATA\XXXXXXX\  32,767 MB
 temp_04_2.ora  G:\ORACLE\ORADATA\XXXXXXX\  25,000 MB


TEMP_05                               30,160 MB RW TEMP LOCAL UNIFORM 1024


NO 8192


 temp_05.ora  G:\ORACLE\ORADATA\XXXXXXX\  30,160 MB


TEMP_06                               25,000 MB RW TEMP LOCAL UNIFORM 1024


NO 8192


 temp_06.ora  F:\ORACLE\ORADATA\XXXXXXX\  25,000 MB


TEMP_07                               25,000 MB RW TEMP LOCAL UNIFORM 1024


NO 8192


 temp_07.ora  F:\ORACLE\ORADATA\XXXXXXX\  25,000 MB


TEMP_08                               25,000 MB RW TEMP LOCAL UNIFORM 1024


NO 8192


 temp_08.ora  F:\ORACLE\ORADATA\XXXXXXX\  25,000 MB


TEMP_09                               50,000 MB RW TEMP LOCAL UNIFORM 1024


NO 8192


 temp_09.ora  F:\ORACLE\ORADATA\XXXXXXX\  25,000 MB
 temp_09_.ora2.ora F:\ORACLE\ORADATA\XXXXXXX\  25,000 MB


TEMP_10                               25,000 MB RW TEMP LOCAL UNIFORM 1024


NO 8192


 temp_10.ora  F:\ORACLE\ORADATA\XXXXXXX\  25,000 MB


TESTING                               14,000 MB RW PERM LOCAL AUTO AUTO


YES 8192



 testing.ora  E:\ORACLE\ORADATA\XXXXXXX\  10,000 MB
 testing2.ora  E:\ORACLE\ORADATA\XXXXXXX\        4,000 MB


TOOLS                               45,000 MB RW PERM LOCAL AUTO AUTO   YES


8192


 tools.ora  E:\ORACLE\ORADATA\XXXXXXX\   5,000 MB
 tools2.ora  E:\ORACLE\ORADATA\XXXXXXX\  20,000 MB
 tools3.ora  E:\ORACLE\ORADATA\XXXXXXX\  20,000 MB


UNDOTBS1                              32,768 MB RW UNDO LOCAL AUTO n/a


YES 8192



 undotbs01.dbf  E:\ORACLE\ORADATA\XXXXXXX\  32,768 MB


USERS                                        250 MB RW PERM LOCAL AUTO AUTO
YES 8192
 users01.dbf  D:\ORACLE\ORADATA\XXXXXXX\     250 MB





CONTROL FILES


 control01.ctl  D:\ORACLE\ORADATA\XXXXXXX\
 control02.ctl  D:\ORACLE\ORADATA\XXXXXXX\
 control03.ctl  D:\ORACLE\ORADATA\XXXXXXX\

REDO LOG GROUPS:
 1       614,440 KB
  REDO_LOG1.ORA D:\ORACLE\ORADATA\XXXXXXX\
 2       614,440 KB
  REDO_LOG2.ORA D:\ORACLE\ORADATA\XXXXXXX\
 3       614,440 KB
  REDO_LOG3.ORA D:\ORACLE\ORADATA\XXXXXXX\
 4       614,440 KB




  REDO_LOG4.ORA D:\ORACLE\ORADATA\XXXXXXX\

Received on Fri Jun 08 2007 - 22:08:57 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US