Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Import Dump in Linux

Re: Import Dump in Linux

From: takesiro <takesiro_at_coral.ocn.ne.jp>
Date: Sun, 14 May 2006 08:05:03 +0900
Message-ID: <e45on5$554$1@news-est.ocn.ad.jp>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US