Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Restore / Import
Care to give us the ORA-xxxx error message?
"Deon" <deon_at_usa.net> 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
Received on Mon Jul 19 2004 - 07:55:17 CDT