Re: Import Problem

Hi Ken,

At first blush it doesn't look like the user kenneth owns any objects,

Were there particular users that owned the objects before?

If you want everything imported you could add full=yes and remove the tables=* from your imp.dat.

Hope this helps,
John

ken.janusz_at_sufsys.com wrote:

>I have created the .bmp file for import to my DB. All I want to do is
>import that data. Here is the imp script:
>
>file=h:\kjanusz\sqlldr\log\nic13.dmp
>log=h:\kjanusz\sqlldr\log\nic13imp.log
>commit=N
>ignore=Y
>analyze=N
>indexes=N
>constraints=N
>grants=N
>rows=Y
>destroy=N
>tables=(*)
>
>And here is the error I am getting:
>
>C:\>imp kenneth/kenjanzz_at_nic13 parfile='h:\kjanusz\sqlldr\ctl\nic13imp.dat'
>
>Import: Release 8.1.7.0.0 - Production on Mon Dec 31 14:43:07 2001
>
>(c) Copyright 2000 Oracle Corporation. All rights reserved.
>
>
>Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
>With the Partitioning option
>JServer Release 8.1.7.0.0 - Production
>
>Export file created by EXPORT:V08.01.07 via conventional path
>import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character
>set
>. importing KENNETH's objects into KENNETH
>Import terminated successfully without warnings.
>
>Yet when I select on the tables there is no data in them! Any idea what the
>problem is? I haven't used Import before so I am new at this. The Export
>ran just fine.
>
>Thanks, and have a Happy New Year,
>
>Ken
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: orantdba
  INET: orantdba_at_netscape.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).