Re: EXPORT IMPORT SIMPLE QUESTION

In our last gripping episode "kush" <kdhakal_at_eline.com> wrote:
> hello! please bear with me, this might be simple question.
> I am trying to do export in user mode and import from the file only
 specific
> tables(by table mode). For that I did following
> exp x/y file=expdat1.dmp (of course x and y has meaning)
> export ran successfully without any warning. And I can see the
> table(employee) exported which I want to import later on.
> Now, I drop the table(employee) which I want to import from this
 export file
> and try to do import in table mode by
> imp x/y file= expdat1.dmp tables= employee
> it gives me following error
> Export file created by EXPORT:V08.01.05 via conventional path
> import done in US7ASCII character set and US7ASCII NCHAR character set
> . importing SA's objects into SA
> IMP-00033: Warning: Table "EMPLOYEE" not found in export file
> Import terminated successfully with warnings.
>
> Any ideas? My question is can we import in table mode from the
 exported file
> which was created in user mode export? if the answer is Yes, why I am
> getting this error.
> thanks in advance.
>
> kush
>
>

Yes, you can export in user mode and import in table mode. Check the export file for the table in question by running imp and specifying the indexfile parameter:

imp x/y file=expdat1.dmp indexfile=expdat1.sql

This will place all of the CREATE statements (tables, indexes) in the file named expdat1.sql. You may then check this file for EMPLOYEE and see if the table actually exists. My first thought is you have misspelled the name -- possibly the table is named EMPLOYEES? There may also be hidden control characters in the table name that will cause it to display as EMPLOYEE but will prevent that spelling from being matched. This is a long shot, so to speak, but it could be a (very remote) possibility.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com
http://www.deja.com/