Re: EXPORT IMPORT SIMPLE QUESTION

Thanks for answering my question, as you said I did imp x/y file=expdat1.dmp indexfile=expdat1.sql fromuser=<username> and the output was:
Export file created by EXPORT:V08.01.05 via conventional path import done in US7ASCII character set and US7ASCII NCHAR character set . . skipping table "x"

. . skipping table "Y"

. . skipping table "Z"
so it went like this for almost half of the table names that I exported, but almost half of the tables including employee table is missing here and also missing from expdat1.sql
what could be the reason?
thanks in advance. I am running Oracle 8.1.5 on Solaris.

kush
"David Fitzjarrell" <oratune_at_aol.com> wrote in message news:920cd2$p7c$1_at_nnrp1.deja.com...
> 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/
Received on Fri Dec 22 2000 - 15:22:30 CST