| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: transfer of large datafile Oracle7.3.4.4 databases to
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_at_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: RROGERS_at_galottery.org
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (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). Received on Mon Jun 18 2001 - 12:18:57 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |