Re: Basic IMP/EXP question

dblocher_at_postoffice.ptd.net (David Blocher) wrote:

>Ok I exported a table without any problem with the following command:
>EXP username/password TABLES=(pc_rslt) log=g:\pcrslt.log file=g:\pcrslt.dmp
>I got no errors from this export.
>Now I dropped the table and now I want to reimport it
>I guess that the following command should work:
>IMP username/password TABLES=(pc_rslt) log=g:\pcrslt.log file=g:\pcrslt.dmp
>But the commands just hangs. The table is recreated but no data is
>inserted.
>I guess I am using the wrong sytax for IMP,
>any suggestion?
>David Blocher

If You would just start Import without all the parameters, You'd be asked whether You want to import the rows also. I think from the commandline the parameter is 'ROWS=Y' (check Your manual ...).

Kersten Received on Thu Feb 08 1996 - 00:00:00 CET