Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Import Dump in Linux
Hi!
Does show it erorrs?
I did't import win - unix, always use sql-loader.
But probably, IMP-00031 error(charactor set)?
You'll export again (with system or sys user exporting ome schema(user))
Then create tablespace before importing.
Finally you are able to import with system user ( option TOUSER, FROMUSER,
IGNORE=Y)
# if import schema name is same, you need type TOUSER and FROMUSER
Regards.
"SubZero" <fcpinheiro_at_gmail.com> wrote in message
news:1147560120.900392.240680_at_v46g2000cwv.googlegroups.com...
>I have a dump of a database 9i (windows) and I need to import it in
> oracle 10g (linux)
>
> There any problem to do this or I just use exp/imp tools ?
>
> are there Any especific parameter to do this ?
>
Received on Sat May 13 2006 - 18:05:03 CDT
![]() |
![]() |