RE: Importing large tables on linux 8.1.7

Add another datafile. Tablespaces can span datafiles. OR if you're trying to compress extents and the initial extent becomes greater than the largest possible datafile, you have at least two options:

1. Don't compress the extents.. COMPRESS=N in your export parfile. (provided the source has multiple extents, all of which are smaller than the largest (linux) datafile.

or

b) Pre-create the segments on the linux database with appropriate sizes. (imp INDEXFILE=filename if you need the ddl) You will need the IGNORE=Y on imp to run without interruption or you will get an error that the segment already exists.

HTH
Shawn M Ferris
Oracle DBA - Time Warner Telecom

> -----Original Message-----
> From: Rachid Moutawakkil [mailto:r.moutawakkil_at_sicodex.co.ma]
> Sent: Thursday, December 14, 2000 4:46 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Importing large tables on linux 8.1.7
>
>
>
> Thanks Shawn,
> For the answer but to problem is not the exported dump file size
> but the tablespace which will hold the table >2GB
>
> trying to enlarge tadafile over 2GB throws an exception :
>
> Cannot extend datafile
> skgfdisp : I/O error
>
> Some k under 2GB work fine
>
> will send you the exact errors as soon as possible
> merci
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachid Moutawakkil
> INET: r.moutawakkil_at_sicodex.co.ma
>
> 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: 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 Fri Dec 15 2000 - 09:17:31 CST