Thanks, I thought that import would not do that for you.
Don't listen to me...
Jared
"Indy Johal" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/28/2003 04:04 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: LOB tablespace
HEre is the full reply as I am looking that mine second reply come before
the first reply and this happend few times today
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. Make sure that you have pre-created the table with LOB column
before importing the LONG RAW column table export
Indy Johal
Indy Johal
Manager, Database Administration
PR Newswire
[EMAIL PROTECTED]
http://www.prnewswire.com
(201) 946-5687 [W]
(201) 400-3960 [M]
"We tell your story to the world."
"Indy Johal" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/28/03 06:49 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
cc:
Subject: Re: LOB tablespace
Sorry I press Sent button in mine earlier reply and what I missed is that
you need to pre-create the table with LOB column before importing the LONG
RAW column table export
Thanks
Indy Johal
Manager, Database Administration
PR Newswire
[EMAIL PROTECTED]
http://www.prnewswire.com
(201) 946-5687 [W]
(201) 400-3960 [M]
"We tell your story to the world."
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/28/03 06:34 PM
Please respond to ORACLE-L
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).
--
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).
