export/import database from 8i to 9i

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Wed, 31 Jul 2002 10:08:41 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA702713278@lnewton.leeds.lfs.co.uk>

Wei,

you cannot mix 'fromuser/touser' and 'full' in the same import.

'touser' is the user you wish to import into and must exist in the 9i
database.
'fromuser' is the name of the user exported from the 8i database and
must be found in the export file.

When importing, it is best to add some other parameters, as follows :

imp system/manager fromuser=wei touser=wei file=c:\expdat.dmp ignore=y commit=y buffer=1024000 log=wei.imp.log

these are :

ignore : doesn't cause errors if a table being imported already exists. Useful if you truncated the tables before running the import. commit : commits evertime a 'buffer' of data is imported. If defaulted, imp will commit once at the very end. You may need big(ger) rollback segments to allow this.
buffer : a decent sized buffer help improve performance and determins how often the import commits.
log : You'll be able to see any error here. If you don't have a logfile, the errors will display on the screen only - and may scroll up before you have time to notice them.

imp help=y will give you a list of the various parameters.

HTH Regards,
Norman.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------

Received on Wed Jul 31 2002 - 04:08:41 CDT