exp/imp table?

[elintrend]

Hi all,

My database only has one user (usrERP) which created for our ERP running on the top of Oracle 8.0.5.2.1/NT 4.0.

There are about 65,000 tables under usrERP schema. My question is can I exp/imp some specified tables everyday as my backup. I only know full dump and user level dump. Can I do table(s) dump? If I can, how to do it? Thanks in advance.

[svk]

Use "tables=..." option of exp.

exp uid/pwd@db all_other_options_that_you_need tables=(tab1,tab3,tab9)

[elintrend]

I will give it a try tonight.
by the way, since I am using exp/imp as one of my B&R. when exporting, -- the following part confused me.

shouldn't I bring db restrict when exporting and importing?
then I have to shutdown and startup restrict????

[svk]

depends on application.

but you may want to use the CONSISTANT=Y option of exp to ensure a good status of exported data.

[dragon99]

Hi, svk,
if you have too many tables to include, you could create a parameter file, do
exp username/userid@host params.dat=filename.
it is easy to add or delete tables from the params.dat.

Dragon

[elintrend]

Hi Dragon,

exp username/userid@host params.dat=filename

what is the format (contents) of filename?

OK, do I have to shutdown db and startup restrict before doing exp/imp? How about constraints?
disable constraint before exp
enable after exp

If latter I want to restore tables from my dump file,
unclear what should I do?

I am search metalink now, but any advice is helpful

Thank you,

[dragon99]

The format is as follows

FILE=ukhub2.dmp
LOG=ukhub2.log
TABLES=(
ABNERMESSAGE,
ABNERUSER,
ADAGENCY,
ADCOUNT,
AIRLINE,
....., --add as many tables as you want
.....,
.....)

The tablenames are comma separated. You could also add your own options such as CONSISTENT=Y. You could find it in ORACLE docs Administrator's Guide.

Good luck to you

Dragon

[rsuri]

Because export is kind of read only, you don't need to disable/enable the constraints.

You may want to do this while doing Import.

- Rajeev