?
Solved

Oracle 10g exp --- not expdp

Posted on 2009-05-08
5
Medium Priority
?
3,033 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 2000 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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
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 information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Suggested Courses

765 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