Link to home
Start Free TrialLog in
Avatar of dgupta70
dgupta70

asked on

ORA-00942 during export

I am doing the export using parfile.following is the content of parfile.
rows=y

indexes=y

grants=y

statistics=compute

full=n

# owner=gk0cp1

tables=(gk0cp1.tas)

direct=y

constraints=y

consistent=y

compress=y


When I run the script I get the error
About to export specified tables via Direct Path ...

EXP-00056: ORACLE error 942 encountered

ORA-00942: table or view does not exist

EXP-00000: Export terminated unsuccessfully


But when I change the parameter direct=y to direct=n then  it works.
Can someone tell me why this is happeneing.

What I need to do to make sure that script works with direct=y

Thanks in advance.
Deepak
ASKER CERTIFIED SOLUTION
Avatar of haidersyed
haidersyed

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of schwertner
schwertner
Flag of Antarctica image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial