Patrice, I built a test server with 8.1.7 and migrated the data from 7.3.4. The database contains 70 GIG of data. I was unable to export the data (free disk space limited on the Novell 7.3.4 server) so I built the database and created the datafiles sized to fit the partitions for the data. The data has date ranges from 1993 to sysdate and I wanted the data ranged by year. I ended up with 140 tablespace and datafiles. The largest datafile is 2 GIG and contains all the data for one year for 1 table. I had to use a database link to copy the data from the prod server to the test server. "insert into select * from table@datalink". It took the better part of a work day to get a years worth of data loaded in the tables. I decided to use individual datafiles and tablespace for the partitions because the prod server datafiles are larger than 2 GIG (3.8 GIG max) and I couldn't export them. THT ROR m���m -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
