EXP Utility - Just Need Data

[fatcodeguy]

Hi,

I need to export (and import) just the data from a database. I currently run this in the command prompt.

exp userid=user/pw@srv tables= tb1,tb2,tb3 file=c:\myfolder\srvdmp.dmp

But it dumps all the constraits, indexes and user grants as well. Is there a way to dump just the table data, or to import just the table data from a dmp with all the other stuff?

Thanks for the help!

 

[SantaMufasa]

SomeGuy,

You can suppress the exporting of each of the items you mention. To see other parameter availabilities, you can issues this command at your o/s prompt "exp help=y". The same explanatory services are available for import: "imp help=y". Specifically, on export you can include in your export parameters:

exp ...grants=n indexes=n constraints=n...

For importing, you can issue the following parameters:

imp ...grants=n indexes=n constraints=n ignore=y

In the above import-parameters set, the ignore=y means "Ignore the fact that target tables already exist." In this case, I presume you will want the tables to be empty before the import. (To empty out the tables, you can issue the command: TRUNCATE TABLE <tablename>;

Let us know if this resolves your needs.

Mufasa
(aka Dave of Sandy, Utah, USA @ 20:58 (31Aug04) UTC (aka "GMT" and "Zulu"), 13:58 (31Aug04) Mountain Time)

 

[fatcodeguy]

Perfect!! Thanks!