Solved

Oracle 10g exp --- not expdp

Posted on 2009-05-08
5
3,012 Views
Last Modified: 2013-12-18
I can't use expdp because certain things for it are not set up.  

So I am trying to use exp.  The command I am using is this:

  exp pitt/******** parfile=export_budget.par

And the error I am receiving is this:

Export: Release 10.2.0.3.0 - Production on Fri May 8 09:54:47 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
Note: grants on tables/views/sequences/roles will not be exported
Note: indexes on tables will not be exported
Note: constraints on tables will not be exported

About to export specified tables via Direct Path ...
EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
EXP-00000: Export terminated unsuccessfully

So, what is wrong?!?!

Parfile contents:

file=budget.dmp
compress=n
grants=n
indexes=n
rows=y
record=n
direct=y
triggers=n
constraints=n
tables=(
BUDGET_ACCOUNTS
,BUDGET_ACCOUNTS_HISTORY
,BUDGET_ACCOUNTS_DETAILS
,BUDGET_ACCOUNTS_DETAILS_HISTORY
,BUDGET_DEPTS
,BUDGET_DEPTS_HISTORY
,BUDGET_GL_INTERFACE
,BUDGET_GL_INTERFACE_HISTORY
,BUDGET_RANGES
,BUDGET_RANGES_HISTORY
,BUDGET_RECON
,BUDGET_RECON_HISTORY
,BUDGET_TARGETS
,BUDGET_TARGETS_HISTORY
,BUDGET_TOTALS
,BUDGET_TOTALS_HISTORY
)
0
Comment
Question by:wcynemy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 

Author Comment

by:wcynemy
ID: 24336252
To all:
I have found that using only 2 tables in the tables list does not produce the error.  It works!
How ridiculous can you get!!!
0
 
LVL 16

Assisted Solution

by:Milleniumaire
Milleniumaire earned 500 total points
ID: 24336395
Tried your parameter file on our 10g system (10.2.0.4.0) and it worked fine with 22 tables listed.

Have you tried increasing the number of tables in the list or does it always fail after the 2nd.  Have you tried changing the sequence of tables in the list - shouldn't make any difference, but you never know!
0
 

Accepted Solution

by:
wcynemy earned 0 total points
ID: 24336458
Milleniumaire:
I found out what the deal was!!!
It turns out my user gave me the wrong table names after the first 2.  So correcting that should and will correct the issue.
I had to take it down to 1 table to get an error message that actually made sense:
EXP-00011: PITT.BUDGET_ACCOUNTS_DETAILS does not exist

It would certainly help if it told me that from the beginning!!!!!
0
 
LVL 48

Expert Comment

by:schwertner
ID: 24336465
Why can not you use Data Pump?

To try to fix your current situation:
1. Check if the Catalog is upgraded to 10.2.0.3

2. try without this parameter
    direct=y
0
 
LVL 48

Expert Comment

by:schwertner
ID: 24336490
I also do not see where is your user name and password.
Try to work under SYS account
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

695 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question