Re: imp not importing row data

From: John Chiu <johnc_at_relsol.com>
Date: Thu, 28 Oct 1999 11:47:13 -0400
Message-ID: <7v9rfi$3gt$1@newsmaster.pathcom.com>

Are you doing export and import to the same database? Are you using the same userid/password? Try specifing tables=(testtab1) in your import and see if it works.

John Chiu

kev wrote in message <381589A7.961905C_at_fast.no>...
>Hi,
>
>I'm trying to get the hang of exp and imp.
>
>I seem to have successfully exported a table with the command:
>
>exp userid=user/pass file=testtab1.dmp tables=testtab1 rows=y
>
>but when I import it with:
>
>imp user/pass file=testtab1.dmp rows=y
>
>I just get:
>
>. importing WWS's objects into WWS
>. . importing table "TESTTAB1" 0 rows
>imported
>Import terminated successfully without warnings.
>
>Why is the data in the rows not imported?
>
>thanks,
>
>- Kev
>
Received on Thu Oct 28 1999 - 10:47:13 CDT