Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3083
  • Last Modified:

Oracle 10g exp --- not expdp

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
wcynemy
Asked:
wcynemy
  • 2
  • 2
2 Solutions
 
wcynemyAuthor Commented:
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
 
MilleniumaireCommented:
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
 
wcynemyAuthor Commented:
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
 
schwertnerCommented:
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
 
schwertnerCommented:
I also do not see where is your user name and password.
Try to work under SYS account
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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