• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 686
  • Last Modified:

data pump

Where is the parameter file saved for a data pump export/import?
0
msimons4
Asked:
msimons4
  • 3
  • 3
  • 2
  • +1
7 Solutions
 
sdstuberCommented:
it isn't

it's a file you create and then you reference on the command line

for example..


expdp parfile=yourfile.par
0
 
slightwv (䄆 Netminder) Commented:
I'm not 100% familiar with the new datapump utilities but I'm not sure the parameter files is 'stored' in any particular location.
0
 
OP_ZaharinCommented:
- the parameter file is the file that you create by using any text editor (eg: notepad) and you can saved it anywhere with .par extension.

- i'm sharing a datapump syntax and how to structure the parameter file and ways to called it:
http://www.orafaq.com/node/74 
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
msimons4Author Commented:
So if I am running the export from the /$ORACLE_HOME/bin directory, then is this where I put the .par file?
0
 
sdstuberCommented:
conceptually, the parfile is the same in expdp/impdp  as it was in classic exp/imp

it's just a text file you create to store your parameters.

it's not actually part of the export or import itself, nor is it part of the database.

I will often zip the par file used export along with the dump file itself.

That way anyone that asks "how was this dump file created" will have the documentation along with it

and the export parfile can be easily modified for use with import
0
 
sdstuberCommented:
you "could" put it in your bin directory.

I wouldn't, I'd put it wherever I was putting the dump file, so I could bundle them in a zip

you can refrence paths in the parfile command line option


expdp parfile=$HOME/myparfiles/testparfile.par
0
 
slightwv (䄆 Netminder) Commented:
You can put it wherever you wish.  I suggest you not put it in an Oracle_home folder.  You might lose them if you ever wipe out that directory.

There is also no reason to run exp from the bin directory.
0
 
msimons4Author Commented:
I thought the expdp had to be run from the bin directory?
0
 
slightwv (䄆 Netminder) Commented:
Nope.  You just need the PATH and ORACLE_HOME set up and you should be able to run it from anywhere.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

  • 3
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now