Oracle-L: RE: Cannot import--URGENT

From: Kimberly Smith <ksmith2_at_myfirstlink.net>
Date: Sat, 11 May 2002 20:48:18 -0800
Message-ID: <F001.0045EF51.20020511204818@fatcity.com>

Ok, first, do not do imports/exports as sys. The last thing you every want to do is move around sys's tables. Second, did sys truly own the tables? Hopefully not. I hate to hear you have non data dictionary tables owned by sys in a production database. Course there are those certain pesky little third party tools that sometimes make you do that but just don't use them.

The fact that you are using different character sets is no biggy. Ignore that comment. It would be an issue if say you were storing Japanese characters
in one database and you were not setup to accept them on the other. For the most part its not a concern. I leave it to you to do your own research on that to see if it truly is an issue.

Seeing as how there are truly no errors in you import I keep going back to the fact that sys is not the original owner of the table. So it tried to import sys's tables into ravi and there were none so all is good.

Unless you are starting/shutting your database or rerunning any catalog related scripts (for upgrades or whatever) you need to forget the fact you know
the sys password. Course there are the occasional grants that need to be done as well but really question why you are signing on as sys and whether
or not it can be done as another user in the database.

-----Original Message-----

Rafiq
Sent: Saturday, May 11, 2002 8:48 PM
To: Multiple recipients of list ORACLE-L

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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Kimberly Smith
INET: ksmith2_at_myfirstlink.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