Solved

Oracle 10g exp --- not expdp

Posted on 2009-05-08
5
2,980 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
  • 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 47

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 47

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and theā€¦
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

708 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now