Re: export/import database from 8i to 9i

Hi Weiwei,

And if the import example was just a case of bad cut and pasting and if you are absolutely sure you have created the user in the 9i DB, and if the error message you quote is correct, then I suspect that maybe you are importing into the wrong database and that you need to set the ORACLE_SID to the appropriate value.

Am I close ...

Richard
"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message news:E2F6A70FE45242488C865C3BC1245DA702713278_at_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:41:06 CDT