Re: export/import

From: bards <bards1888_at_yahoo.com.au.au>
Date: Thu, 25 Aug 2005 05:03:47 GMT
Message-ID: <TicPe.216$uQ6.7923@news.optus.net.au>

Mark Bole wrote:

>
> I can't answer your exact question. Surely a test is in order. (Your
> question about "affecting 8.1.7" is confusing... since you are obviously
> not importing into the 8.1.7 database). Are the databases on the same
> server?
>
> But I will note that I have *never* needed or wanted to perform a FULL
> exp/imp. User-level (schemas) or table-level exp/imp has always been
> sufficient and beneficial to accomplish whatever I needed for numerous
> production environments, as far back as version 6 and all migrations
> since. Is there something you wish to accomplish that requires FULL?
>
> -Mark Bole
>
>
>

Yes, I didnt mention the detail in an attempt to make the question as simple as possible. You are correct in your assumption that both databases are on the same server.

This is an upgrade of a production 8.1.7 database to a 10g installation on the same machine. I dont want to upgrade the 8.1.7 database inplace as it serves as my 'reversion plan'. I've created the new 10g database and want to get everything from 8.1.7 into 10g. Use level schema exports imply me having to do all the other system stuff up front unless I'm mistaken, that is create users, create roles, grant privs etc. Am I wrong ? It seems like a lot of work with the potential for human error (my typos etc).

Ta. Received on Thu Aug 25 2005 - 00:03:47 CDT