Re: Imp troubles

From: Luke Scharf <luke_at_vt.edu>
Date: Wed, 03 Jul 2002 10:45:32 -0400
Message-ID: <afv2oe$810$1@solaris.cc.vt.edu>

I ran imp from the command line with the same results as through the OEM.

The dump file is about 250 mb and local, but the machine I'm using is a castoff UltraSparc 1. This is my "play machine" so that I can learn Oracle and do Bad Things to the database withouth jeapordizing our production system.

To fully expose my level of expertise, I just discovered the IMPORT.LOG file... Analyizing this file is where I should have started. It looks like this:
> Export file created by EXPORT:V08.01.07 via conventional path
>
> Warning: the objects were exported by GYPSY, not by you
>
> import done in US7ASCII character set and US7ASCII NCHAR character set
> . importing SYSTEM's objects into SYSTEM
> IMP-00017: following statement failed with ORACLE error 1119:
> "CREATE TABLESPACE "GMTEMP_TS" DATAFILE '/muddle/oracle/sts/gmtemp01.dbf' S"
> "IZE 83886080 AUTOEXTEND ON NEXT 2097152 MAXSIZE 83886080 DEFAULT S"
> "TORAGE(INITIAL 65536 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCRE"
> "ASE 0) ONLINE TEMPORARY "
> IMP-00003: ORACLE error 1119 encountered
> ORA-01119: error in creating database file '/muddle/oracle/sts/gmtemp01.dbf'
> ORA-27040: skgfrcre: create error, unable to create file

I am running Oracle 8.1.7 on my test machine, so the versions should match. I already ran headlong into the 8.1.7->8.1.6 exp/imp gotcha... :-)

Thanks again!
-Luke

On Wed, 03 Jul 2002 10:32:29 -0400, Anurag Varma wrote:

> Did you try running the imp from the command line? How big is the dump
> file? What os, db version? If unix/solaris, what does top show? Does the
> import work with a much smaller export dump?
>
> I have seen imp to be slow for various reasons (dump file on slow NFS
> was one of them)
> .. but never seen it stuck...
>
> Anurag
>
> "Luke Scharf" <luke_at_vt.edu> wrote in message
> news:afv0v3$5gm$1_at_solaris.cc.vt.edu...

>> I've managed to install Oracle server, and get the OEM running.  I've
>> also managed to get the backup/restore wizards to run to completion on
>> my exp'd data.
>>
>> The problem is that when I run imp (or the OEM import wizard), imp will

> chew on

>> my dump file for about an hour and report no error messages - but I
>> can't

> find

>> where any tables were created or users/schemas added.
>>
>> Can anyone get me started on solving this problem? Any ideas about
>> what's happening?
>> What would you look for?
>>
>> Thanks in advance!
>> -Luke

Received on Wed Jul 03 2002 - 09:45:32 CDT