tonydba
asked on
export whole database
Can you please tell me this is right to export whole database using the par file
Export:
directory=DATA_PUMP_DIR
dumpfile=expdp_PCHARTKWT_F CHARTKWT_0 4022014.dm p
logfile=expdp_PCHARTKWT_FC HARTKWT_04 022014.log
schemas=??
what we need to add if we want to export whole database ie all users
Export:
directory=DATA_PUMP_DIR
dumpfile=expdp_PCHARTKWT_F
logfile=expdp_PCHARTKWT_FC
schemas=??
what we need to add if we want to export whole database ie all users
ASKER
Please make it parfile way
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Remember that directory here is an alias, pointing to some physical path. It will require read write permissions inside the database: http://www.orafaq.com/wiki/Datapump.
ASKER
We name this file exportjob.par
and go to the os level
and give
nohup exportjob.par
Is that enough..
and go to the os level
and give
nohup exportjob.par
Is that enough..
nohup $ORACLE_HOME/bin/expdp parfile=<some path to the directory for>par_file.par
Assuming your other ORACLE environment variables are right.... I generally don't use the nohup option, as there's an internal way to monitor status. Your call.
Assuming your other ORACLE environment variables are right.... I generally don't use the nohup option, as there's an internal way to monitor status. Your call.
nohup $ORACLE_HOME/bin/expdp parfile=exportjob.par
This suffices as per your file name
This suffices as per your file name
Agree with dvz
There is an option in Dba_datapump_jobs data dictionary to check progress of data pump job
Anyway its ur call.. if you wish to monitor the process at is level its fine
There is an option in Dba_datapump_jobs data dictionary to check progress of data pump job
Anyway its ur call.. if you wish to monitor the process at is level its fine
@wasimibm -- doesn't your syntax imply that the parameter file is in the default directory?
We may be confusing one another with the author's question (ID: 39989754).
We may be confusing one another with the author's question (ID: 39989754).
Yeah may be.. let's leave it out for authors knowledge.. I logged in from my mobile.. was bit slow in typing.. haven't seen your first comment.. after I saw it posted another one which I agreed with you..
@Tony -try out and we are there in case of any further help ...!!!
@Tony -try out and we are there in case of any further help ...!!!
You might have changed the requirement a little bit now and would have asked out this probably
https://www.experts-exchange.com/questions/28409087/all-schema-export.html
probably, you better explore data pump utility as a whole, you can find a lot of interesting things with many options
all schemas is as good as whole data base, however you can do that, instead of
full=y
you have use schemas clause like
schemas=schema1,schema2
eg:
schemas=scott,hr,system
and for par file
userid=system/<password>
directory=DATA_PUMP_DIR
dumpfile=expdp_PCHARTKWT_F CHARTKWT_0 4022014.dm p
logfile=expdp_PCHARTKWT_FC HARTKWT_04 022014.log
schemas=system,scott,hr
For Startup's there is a good site, which shows illustration with commands,
http://www.oracle-base.com/articles/10g/oracle-data-pump-10g.php
check this out in your free time
https://www.experts-exchange.com/questions/28409087/all-schema-export.html
probably, you better explore data pump utility as a whole, you can find a lot of interesting things with many options
all schemas is as good as whole data base, however you can do that, instead of
full=y
you have use schemas clause like
schemas=schema1,schema2
eg:
schemas=scott,hr,system
and for par file
userid=system/<password>
directory=DATA_PUMP_DIR
dumpfile=expdp_PCHARTKWT_F
logfile=expdp_PCHARTKWT_FC
schemas=system,scott,hr
For Startup's there is a good site, which shows illustration with commands,
http://www.oracle-base.com/articles/10g/oracle-data-pump-10g.php
check this out in your free time
I've requested that this question be closed as follows:
Accepted answer: 500 points for wasimibm's comment #a39989402
for the following reason:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Accepted answer: 500 points for wasimibm's comment #a39989402
for the following reason:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
The asker's question migrated over the life of this thread. As your award to wasimibm for a revised answer ID: 39989402, one of my contributions, ID: 39989764, answers the author in ID: 39989754.
Please reconsider a split.
Please reconsider a split.
I agree ..!!!
dvz comment to be accepted as an assisted solution
dvz comment to be accepted as an assisted solution
Could you accept this ID: 39989402 and give him 500 points.
expdp system/password@db10g full=Y directory=TEST_DIR dumpfile=DB10G.dmp logfile=expdpDB10G.log
impdp system/password@db10g full=Y directory=TEST_DIR dumpfile=DB10G.dmp logfile=impdpDB10G.log
reference from oracle-base
in your case, you just have to add
FULL=Y
in your parameter file, you don't need schemas clause