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: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
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.
[EMAIL PROTECTED]
-----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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
