Re: Restore / Import

deon_at_usa.net (Deon) wrote in message news:<500df492.0407181725.18abdff2_at_posting.google.com>...
> I am running Oracle 9i on Win2003 and am trying to restore a database
> that was backed up from a Unix environment. I am far from a Oracle
> expert just know a few commands to get around so please be gentile on
> me.
>
> I am using the following commands
>
> create user dbo_UT identified by dbo1;
> grant dba to dbo_UT;
> alter user dbo_UT default tablespace users;
>
> After creating the user and table space I run the flowing
>
> imp userid=system/please file=dbname.dmp fromuser=dbo touser=dbo_UT
>
> this does not always work more often fails with a null error that it
> can not import. But some times it does work. I have found that if I
> replace the dbname.dmp file with a fresh copy before I start it is
> more likely to work however this is no longer the case.
>
> The database is fairly large about 890 Meg can anyone offer me any
> advise
>
> DMn

beside the question of exactly what error did you get, can you mention how you move the file from UNIX to Windows? Hopefully you did not use FTP in ACSII mode.

ed Received on Mon Jul 19 2004 - 12:27:01 CDT