Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

How can I dump a remote 10G database to a local directory using expdp (the data has binary doubles, so exp won't work)?

I'm trying to create a database dump of a remote 10G database.  Using exp, I can get some of the objects, but the schema uses new 10G functionality that is not supported by exp (binary doubles), so I can't get a number of the tables and the logic fails:

. . exporting table              BILLVALIDATEPARAM
EXP-00104: datatype (BINARY_DOUBLE) of column DATAVALUE in table ITRONEE.BILLVALIDATEPARAM is not supported, table will
not be exported
. . exporting table               BILLVALIDATETEST^C

Looking online, I saw that I need to move to expdp to get the 10G stuff.  I've been messing around with that, but I haven't been able to make it work (even after figuring out that I had to make the server side directories from a sql prompt).  Latest errors:

C:\OraHome_1\bin>expdp itronee/itronee@itronee DUMPFILE=itronee.dmp DIRECTORY=dpdata1 SCHEMAS=itronee logfile=expdp.log

Export: Release 10.1.0.4.0 - Production on Monday, 10 April, 2006 17:36

Copyright (c) 2003, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production
With the Partitioning, OLAP and Data Mining options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 475
ORA-29283: invalid file operation

 I saw that someone created a local database with a database link to the remote database and then dumped from the local database, but I can't create the link (well, more accurately, I can't use the link I create to access the data, but I can create something that smells like a link).  I tried in SQL Plus and in the new Web Enterprise Manager, with limited success.  Any help would be appreciated.
0
davidgordonhill
Asked:
davidgordonhill
  • 2
1 Solution
 
schwertnerCommented:
Why you do not install Oracle client 10g on your machine.
The Export executable will have the needed functionality.

In 10g Rel. 1 the new export tools (like Data pump, etc.) are not in good standing.
Only in Release 2 they can work. Oracle supports knows which scripts has to be rerunned, but this is
taugh task.
0
 
davidgordonhillAuthor Commented:
I had 10G on my client connected machine.  I just didn't have access to the server from there, and the new stuff dumps the files on the server instead of the client.  I ended up calling the DBA to dump the DB to a network drive so I could grab it from there.

Thanks,

David
0
 
schwertnerCommented:
If you have troubles to connect 10g possibly you run in the "normal bug" of 10g:

This is the typical 10g trap.

Go to the remote 10g installation.
In ...\network\admin open listener.ora

see

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\Ora10g)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = test)
      (ORACLE_HOME = D:\Ora10g)
    )
  )

Add the entry
    (SID_DESC =
      (SID_NAME = test)
      (ORACLE_HOME = D:\Ora10g)
    )
with regard to the particular Oracle Home and SID Name.

Restart the listener:
c:>lsnrctl stop
c:>lsnctl start

Thats all.

0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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
Tackle projects and never again get stuck behind a technical roadblock.
Join Now