Jared
This is not the case. I had imported a 150 Gig table containing LONG RAW column to BLOB with simple Export /Import sometime back last year and the only thing is that the column name given to BLOB column is same. This is export import from 81.7.3 non -partitioned table to 8.1.7.3 partitioned table
Indy Johal
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED] 07/28/03 06:34 PM
|
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Re: LOB tablespace |
You won't be storing LOB's, you will be storing LONG's.
Oracle does not automatically convert LONG to LOB for you.
You will have to do that yourself ( check on MetaLink ) after
you import the data.
Assuming that your new database will be using LMT's ( locally
managed tablespaces ) I would think just set PCTFREE and
PCTUSED to whatever you were using previously.
HTH
Jared
"Ehresmann, David" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/28/2003 03:09 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: LOB tablespace
I am going to import an Oracle 7 database into an Oracle 8.1.7.0.0
instance
that I am going to make. I have 31 tables of which 11 hold LONG and/or
LONG
RAW column datatypes. What storage clause should I put on the tablespace
to
hold the LOBs most efficiently?
thanks,
David Ehresmann.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ehresmann, David
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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).