×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Converting from EXP to EXPDB

Converting from EXP to EXPDB

Converting from EXP to EXPDB

(OP)
I am trying to convert my backups from using EXP to using EXPDB, but the syntax is way different and I get errors with no backup done.

The command I am trying is:
expdb <user>/<pass>@SID DIRECTORY=e:\Oracle_bkup dumpfile=orcldmp.exp logfile-orcldmp.log

I get the following errors:
ORA-39002
ORA-39070
ORA-39087

The database schema and all is from a PTC Windchill system.

RE: Converting from EXP to EXPDB

What is EXPDB? Oracle has an application called EXPDP (Data pump). Also why use expdp when RMAN (Recovery Manager) comes with the database and is specifically made to do database backups. and recover the database if an error occurs.

To help you the error is occurring because expdp uses a directory object, not a directory path. for example if you set up a directory path as the SYS user using the following commands

CREATE OR REPLACE DIRECTORY
DATA_PUMP_DIR AS
'e:\Oracle_bkup\';

GRANT READ, WRITE ON DIRECTORY DATA_PUMP_DIR TO <USER_RUNNING_THE_EXPDP>;

Then your command would be

expdb <user>/<pass>@SID DIRECTORY=DATA_PUMP_DIR dumpfile=orcldmp.exp logfile-orcldmp.log

The directory objects folder MUST be on the server running the oracle database and the folder (e:\Oracle_bkup) must be owned by the user running the oracle database and that user must have read/write priviledges on the folder. The dumpfile will be created in that folder.



Bill
Lead Application Developer
New York State, USA

RE: Converting from EXP to EXPDB

(OP)
My mistake, I am trying to use expdp.
Doesn't exp and expdp come with Oracle, too?
What makes RMAN better than expdp for a simple backup?

RE: Converting from EXP to EXPDB

expdp can be used to restore individual tables but doesn't protect against things like corrupt data files or a totally hosed database. RMAN is the backup tool for oracle and can totally recover a corrupt or damaged database. And if you are running in archive log mode (always for production databases) it will recover your database to the last committed transaction.
expdp is a table backup tool that is a single point of time backup and will only allow the particular table to be reloaded to the specific point of time that the backup was performed.

Bill
Lead Application Developer
New York State, USA

RE: Converting from EXP to EXPDB

(OP)
Thanks Bill

In my application expdp will be fine as it is not a transaction based 24/7 system. The Windchill application is storing engineering data files, reports and some meta data about these files.

RE: Converting from EXP to EXPDB

Thats fine. However you should have at least one good RMAN backup or a physical copy of the datafiles when the database is down so if you get a corrupted data file or your server crashes you can recover your database. Make sure to include the control files and store them on a different server or on a backup medium. as for the exppd dumpfile keep at least one good copy of the previous dumpfile in case the dumpfile gets corrupted.

Bill
Lead Application Developer
New York State, USA

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close