| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Cannot import--URGENT
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). Received on Sat May 11 2002 - 22:08:26 CDT
 |
 |