Re: 8.1.7.4 to 9.2

I created a new database in 9i and used export/import so that I could

1. Reorganise all the file systems / mount-points and file-naming convention
2. Create Locally Managed Tablespaces [incl SYSTEM] with Auto Allocation and Automatic Segment Space Management

Point b. is what you would be looking for with Export/Import.

Of course, you must have enough downtime available to Export-Create-Import

Hemant

At 12:39 PM 11-02-03 -0800, you wrote:
>Guru's
>
>We are planning to move to 9i from 8.1.7.4 in the near future. The two
>options we are considering are
>
>a) Migration from 8.1.7 to 9.2
>b) Install 9i and then use export , import to get the data from version 8i.
>
>If my memory serves me right I remember reading an article somewhere which
>says that we could not use all the new features of 9i if we went ahead with
>the migration path.
>
>Could you please provide your inputs as to which way is better than the
>other with pros and cons of both.
>
>Thanks in advance.
>
>Rishi.
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author:
> INET: Rishi.Jain_at_VerizonWireless.com
>
>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: 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).

Hemant K Chitale
My web site page is : http://hkchital.tripod.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  INET: hkchital_at_singnet.com.sg

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: 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).