Re: ORACLE Data Partitioning?

Try this.

Create 4 different tables on 4 different disks. For instance:

          1991 data    - Disk 1
          1992 data    - Disk 2
          1993 data    - Disk 3
          1994 data    - Disk 4

Then create a view:
          CREATE VIEW TOTAL_DATA AS
                        SELECT * FROM 1991_DATA
                        UNION
                        SELECT * FROM 1992_DATA
                        UNION
                        SELECT * FROM 1993_DATA
                        UNION
                        SELECT * FROM 1994_DATA;

I haven't used this, but I thought that this thoery may help if you're stuck.

Michael Armstead Received on Wed May 03 1995 - 00:00:00 CEST