RE: Cannot import--URGENT

I was having similar problem with one of our table while exporting using direct=y. No error either from export or while importing but no record with data inserted although doing count it was giving right count.

Solution was to export that particular table with conventional path i.e. not using direct while export. But in your case , it looks your not using direct=y right. Oracle support could not figure it out this problem. Platform for export and import was HP-UX 11. export version 8.1.6.2 and importing to 8.1.7.2 database. Anyhow it was problem was with export as size of dmp file size was visibly totally different.

Regards
Rafiq

Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Sat, 11 May 2002 19:08:25 -0800

Ravindra - Just from looking at your error messages, it sounds like the two Oracle systems have different character sets. I would check this out if I were you. The other thing to check for is whether the tables are created in a different schema than you are expecting. As SYS or SYSTEM,

     select owner from dba_tables where table_name = 'MYTABLE'; If the table was actually created, but in a different schema, this query should tell you where.
Again, these are just a couple of ideas for you to look into, and the other people who have replied have also given you some good ideas to look into. Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Saturday, May 11, 2002 8:23 PM
To: Multiple recipients of list ORACLE-L

I am trying to import from my production database to another database.Table level export
was done on the production databse for 4 table.It ended w/o any errors.

When I am trying to import to anther user on a different datasbe the import compltes
successfully without any warning but no table/records are imported The tables being imported are not existing in the new user's schema. I have tried this on 8.1.7 to 8.1.7 and also on 8.1.7 to 9.0.1.

These tables on the production database are protected so I can export them only as sys user.I am attaching the log from the import.What is the problem. Am i missing anything

imp sys/change_on_install fromuser=sys touser=ravi file=g.dmp log=g.log

Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production With the Partitioning option
JServer Release 9.0.1.1.1 - Production

Export file created by EXPORT:V08.01.07 via conventional path import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set export client uses WE8ISO8859P1 character set (possible charset conversion) export server uses US7ASCII NCHAR character set (possible ncharset conversion)
Import terminated successfully without warnings.

Ravindra

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
   INET: DWILLIAMS_at_LIFETOUCH.COM

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).




MOHAMMAD RAFIQ


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohammad Rafiq
  INET: rafiq9857_at_hotmail.com

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).