Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Import error...IMP-00033: Warning: Table NOT found.

441858Aug 31 2009 — edited Sep 11 2009

Oracle 11gR1 RHEL 5 64bit.

Hi all.

I am having problems importing data. I am using exp/imp not datapump. I just have too many issues with datapump.

Any way here are how my logs look. I'm thinking that it is maybe a NLS Character set variable perhaps?

Export log:

Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8MSWIN1252 character set (possible charset conversion)

About to export specified tables via Direct Path ...
Current user changed to IIQ
Table DICOM_OBJECT will be exported in conventional path.
. . exporting table DICOM_OBJECT
...........................................................................
...........................................................................
...........................................................................
...........................................................................
...........................................................................
...........................................................................
...........................................................................
...........................................................................
...........................................................................
...........................................................................
...........................................................................
...........................................................................
...........................................................................
...........................................................................
...........................................................................
...........................................................................
...........................................................................
...........................................................................
...........................................................................
...........................................................................
...........................................................................
...........................................................................
...........................................................................
...........................................................................
..................................
18340 rows exported
Export terminated successfully without warnings.

Import Log:

Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Export file created by EXPORT:V11.01.00 via direct path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8MSWIN1252 character set (possible charset conversion)
IMP-00033: Warning: Table "DICOM_OBJECT" not found in export file
Import terminated successfully with warnings.

I havent done exp/imp in quite a while, so any help would be appreciated.

Thanks.