Oracle expdp and impdp

Running Oracle Express 10g version 2.When I try to run expdp, impdp, export, or import I get an error saying that they are not valid commands. I was following the 2 day DBA tutorial when I ran into this problem. I did HELP INDEX and none of them showed up.Any idea what the problem might be? ...

Oracle expdp/impdp quick question

I just did a export of around 20 schemas from my production database. expdp userid=system/pwd schemas=('a','b',...'x') dumpfile=xxx logfile=yyyy directory=....Is is possible for me to import just one particular schema into my test database by specifying the schema of interest??? (in this case schema ...

Using impdp to restore entire db

If we're using impdp to restore an entire db, is it better to drop the database, re-create it, then perform the impdp? Or can we perform the impdp directly over the existing incarnation?---=Chuck ...

IMPDP with constraints

I'm a newbie in Oracle datapump and I've a question.I need to migrate a database from a server to another server.I used expdp system/password@SID directory=EXP_DIR SCHEMAS=schema1,schema2 dumpfile=exp_all_schemas.dmp logfile=exp_all_schemas.logto export data from first server.Now on the second serve ...

impdp Command

I caught in a tricky situation while importing the oracle9i database into my oracle10g database into my test environment.I received oracle export in around 9 dump files. But I dont know the username(Schema) and tablespaces available in that dump file.I create my empty database and just import the du ...

impdp not importing anything

I have copied across datapump files which were created on our test system last night (RHEL 5.5, 10.2.0.4), and am wanting to import some tables in, however, when I run the import command, I just get the Datapump banner. The parfile used to run the backup is as follows:dumpfile=full_101115_0500_datap ...

IMPDP - ORA-31644: unable to position to block number

Sorry to bother, but I'm under deadline pressure and my brain is fried.Doing IMPDP11.2.0.2 source, 11.2.0.1 target (no time to patch as of yet...)UTF-8 NLSTriggering utility by either cmd line or EntMgrEither gives...by cmd line...Connected to: Oracle Database 11g Release 11.2.0.1.0 - 64bit Producti ...

Oracle Data pump import (impdp) broken on 10G Standard Edition?

I can not get data pump import to work on standardedition (10.1.0.3 on RedHat ES 4)I always get a "ORA-00439: feature not enabled: Streams Capture" even if I just start impdp withoutspecifying any dump files on the command line('impdp nnn/password')I know Streams capture is an Enterprise Ed. only fe ...

Oracle 10g impdp speed?

Has anyone used the new 10g import(impdp) and seen a speed improvement over the old import? I tried a small test and it actually was slower. ...

Oracle Problem with EXPDP/IMPDP with Parameter file

I want to execute EXPDP/IMPDP command of Oracle10g as below.I am using Windows XP Professional with SP2.And Oracle 10g release 10.1c:>expdp user1/user1 parfile=c:\program Files\xyz.txtThis command gives LRM-00109: could not open parameter file 'C:\Program'LRM-00113: error when processing file 'C: ...

Oracle impdp over dblink from 10.1.0.3 to 10.1.0.2

I am trying to copy some schemas from a test environment (Oracle EE 10g 10.1.0.3 on Linux ) to my development environment (my PC with Ora10g 10.1.0.2 on Win XP) using impdp and a dblink but I get an error (ORA-39006 , ORA-39022) stating that version 10.1.0.3 is not supported... Any idea of a workaro ...

Oracle IMPDP error

I use impdp utility to import a dump file as following steps:SQL> CONNECT SYS as SYSDBASQL> GRANT CREATE ANY DIRECTORY TO customer;SQL> CREATE OR REPLACE DIRECTORY data_pump_dir AS 'd:\temp';SQL> GRANT READ, WRITE ON DIRECTORY data_pump_dir TO customer;SQL>exitD:\Temp\impdp customer/c ...

Oracle impdp: table_exists_action

Is there any way to configure impdp so that table_exists_action=replace when table definition is changed, if not use table_exists_action=truncate?I am using impdp to create test/developement schema from production schema and it is possible that tables in test/development schema may have been altered ...

Oracle Data Pump - Import command - impdp

What is the proper command line for importing one csv file to a table? I created schema using DBArtisan and imported 500k records CSV file with 'sqlldr'. I'd like to compare results using 'impdp'. I do not want to study the number of documents posted on the Internet. None of the many I saw has a use ...

Oracle SDO_INDEX_METADATA not populated after impdp

I have a table in instance 1 that I would like to export to instance 2. I use expdp to export the table from instance 1 and impdp to import the table into instance 2. Syntax for the import as follows:impdp mapinfo/mapinfo TABLES=COUNTY DIRECTORY=opump DUMPFILE=county.dmp LOGFILE=import.logThe table ...

Oracle I am trying the expdp and impdp utility getting error

I am trying the expdp and impdp utility, as per the documentation I logged in as sys and created a directory datapumpt in the location 'C:\oracle\odp' , i did grant the read and write privilege to my user_id.when i tried the expdp command in the prompt its throwing errors:Ora:39002 invalid operation ...

how to impdp in oracle 10g

i have export data from user and create a dmp file.how to impdp that dmp file in to another user.please give me steps. ...

Oracle impdp and expdp failed due to following error

to every onewhen ever i issue impdp or empdp command it gives the errori have used intesivly data pump but i am not get the idea that why this going to do on this DBserver only. even i have just give impdp username and passward but the error is same if any one have information then me is waiting for ...

Oracle IMPDP IS VERY SLOW WHEN IMPORT INDEXES

I have a new server Fujitsu Primepower 650 with Solaris 10 that it will be my new database server and try to import the full database (export with expdp) of my old database server that have RHAS3, the tables data take 45 min. (+/-) to import, but the indexes take a very long time 8 hours (+/-) and c ...

Oracle impdp command and remap parameters

I've to perform an import/export procedure (about 6 GB of data). To import my data I want to use the impdp command (Oracle 10g rel.2). I'd like to know:1. the option REMAP_SCHEMA changes just the target user and not the tablespace and datafiles, is it correct?2. is it possible to move data in a new ...

How can I replace existing oracle-sequences using impdp?

I use impdp to transport table data from one database-instance to another (on a regular base).I do this by using a database link.Here is the content of the parameterfile for the impdp:NETWORK_LINK=dbl_backofficeINCLUDE=TABLE:" in ('SSU_CUSTOMERS','SSU_ORDERS','SSU_ORDERLINES')"INCLUDE=SEQUENCE:" in ...

impdp ORA-02421 on Oracle 10.2.0.1 and 10.2.0.2

The impdp utility crashes the import process with ORA-02421 for a schema which starts with a number on both Oracle RDBMS versions : Oracle 10.2.0.1 and 10.2.0.2.I tried to apply patch 4671082 to Oracle 10.2.0.1 but it doesn't work and its a known issue.Eg.Processing object type SCHEMA_EXPORT/PROCEDU ...

Oracle Problem with impdp

I have a strange problem with iumporting a dumpfile into my oracledatabase (Oracke 10gR1 running under windows XP). C:\>impdp system/daniel@sigkopie directory='D:\Documents and Settings\DE11605\Desktop\oracle-backup' dumpfile=SIG.dp remap_schema sa:ECSImport: Release 10.2.0.1.0 - Production on Di ...

Oracle impdp.exe 10g -> 10gXE problem

Hi, i have a little problem with Oracle 10g XE. In our company we have full oracle 10g. Now we have to do backup server so we choose XE edition. But when we trying to import *.dmp file with impdp.exe we have an error. we did new database like this: # create new foldersmd c:\oraclexe\app\oracle\admin ...

Oracle IMPDP

I am having the worst time with a Data Pump Import. I am using the following command:impdp <username>@<remotedb> DIRECTORY=<Directory "X" that points to "\user\chips\datapump\"> DUMPFILE=<" in directory "X">CONTENT=ALLREMAP_SCHEMA=<devSchema>:<tstSchema>TABLE_EXIS ...

Oracle after impdp

:\expdp>impdp franquicias/franquicias dumpfile=faccli.dmp logfile=imp2faccli.log transform=segment_attributes:n DIRECTORY=export_dumpImport: Release 10.2.0.1.0 - Production on Martes, 05 Septiembre, 2006 14:31:07Copyright (c) 2003, 2005, Oracle. All rights reserved.Conectado a: Oracle Database 10 ...

Oracle impdp - does it work for XMLType columns ?

Does impdp handle non-schema based XMLType columns OK ? We're getting errors such as "ORA-26065: check constraint cannot reference column, SYS_NC00007$, in direct path load" when importing a database schema that was exported from a different server. Both servers are 10.2.0.1 64-bit RedHat linux.Are ...

Oracle How to impdp a database to another computer ?

Oracle experts,I try to import a database whose dumpfile is lying on my local computer via impdp onto another computer.My problem is that I don't know how to tell impdp that my file is on my local computer and not on my server.If I use the directory and dumpfile options then the server searches on i ...

Oracle datapump impdp error due to streams capture

Last night I was trying to setup a light backup/restore scheme using datapump expdp and impdp.Env: oracle 10g, redhat EL 3.The backup (expdb) exports a schema and works smooth.The import for the whole schema or for a given table fails horribly with:impdp system/***** directory=dpump_dir_1 dumpfile=a ...

Oracle impdp

Can I use for impdp utility my "own" genereted file, not that one which is generated by expdp? ...

Oracle ORA-39001, ORA-39000 and ORA-31619 Errors while impdp from linux to windows

When I use expdp and impdp on a database inside the same machine or between 2 machines using the same OS everything is OK.But when I want to cross the same database expdp and impdp, for instance:I expdp on linux RedHat 4 ES and want to impdp on Windows XPthen I have the folowwing errors:ORA-39001, O ...

Oracle expdp on 10gR2 and impdp on 10gR1

Is it possible to expdp on oracle 10gR2 and impdp on Oracle 10gR1?If not as I guess how may I cross over this problem?May be I should use exp and imp?or expdp and impdp with particular options?I need help ...

Oracle Impdp - ORA-39126: Worker unexpected fatal error in KUPW$WORKER.LOAD_METADA

I am trying to refresh my local DB and getting this error.I have recreated(drop and create) the SR user and tried importing the fresh copy.Import is working fine on the new Database i.e Deleting and creating the database.pl. help me finding the solution.version : 10.1.0.2.0 _____________________impo ...

Oracle impdp unable to open log file

I have installed Oracle10Rel2 on a Windows 2000 server. I managed to get anexpdp from a machine but trying to do import I keep getting an error about writinga log file. What else do I need to set? I even tried setting my directory value tothe location I have UTL_FILE_DIR set to for other processes. ...

Oracle Data Pump impdp DIRECTORY object for dumpfiles on shared network drive

Our customer has delivered Data Pump dumpfiles to a Linux Server where Oracle is not installed. We are attempting to use impdp from a Windows 2003 Server with Oracle release 10.2.0.3 installed. The following steps have been taken:1) Established a DIRECTORY object DATA_PUMP_DIR and verified that it w ...

Oracle IMPDP slow for partitioned table

I am doing an IMPDP(10.2) for an partition table.The export table has 600 partitions with 40 million rows per partition. I needto move the table to another system. I export in batches (36 partitions) at atime.The export runs quick (less than 4 hours), but the import is very slow (slowerthan what the ...

Oracle Trouble with REMAP_TABLESPACE in impdp

impdp system/******** REMAP_TABLESPACE=marius:chado DIRECTORY=dmpdir2 DUMPFILE=okeiko_tool.dmpResult in (did not include the entire output):Import: Release 10.2.0.1.0 - Production on Onsdag, 10 Januar, 2007 12:22:57Copyright (c) 2003, 2005, Oracle. All rights reserved.Connected to: Oracle Database 1 ...

Oracle IMPDP: How to update table, if primary-key already exists?

I am using the impdp utility of Oracle 10g. I want that if the table to which I am importing has the same primary key as the data of .dmp file (from which I am importing), then that row in table will be updated, and if the primary key doesn't exists, that that row is inserted.impdp allows you to spe ...

Oracle Impdp Problem

I'm trying to import tables from a Oracle 9i in to APEX 10.1 using sqlplus data pump.After opening a SQL command line prompt on the server PC and successfully logging onto the oracle database I've tried following the manual instructions to import the tables using:"impdp system/password schemas=hr di ...

Oracle expdp & impdp ????

I was trying out expdp and impdp options in oracle 10g. I was following instructions of a document which was posted in the net. When I give expdp command following error accured. can somebody tell me what should I do ????Also please let me know if there any examples which describes expdp and impdp. ...

Oracle Impdp - import objects into two tablespaces

HiI have exported a schema using the impdp utility from one database and plan to imort the schema to a different database. The schema in the source database was in one tablespace, but I want to place indexes in a separate tablespace in the destination database. My idea is to do two import operations ...

Oracle IMPDP question -- Replace all objects

QuestionI have a situation where I would like to use Data Pump to refresh a test database schema weekly from our production instance schema. I would like to set up a job to do this with data pump. I can use data pump (impdp) with success using the network_link with no issue. My question is does anyo ...

Oracle Help with expdp and impdp

I've got the mission to build a commandline to export a schema from our database, a oracle 10.1.0.5. I'm trying to get to know the expdp/impdp functions.This is my expdp-call:expdp my_schema/password@mydb schemas=myschema directory=data_pump dumpfile=MYSCHEMA_DUMP.dmp logfile=MYSCHEMA_LOG.logAnd it ...

Oracle ExpDp/ImpDP Error

I am New In Oracle 10g I want to Import a dmp file which was Exported by oracle 9i My Problem is Can I do it (import in 10g from 9i)My Second Problem is when I issue EXPDP or IMPDP Following Error is Come .........pls give me a solution ..........C:\>expdpExport: Release 10.1.0.2.0 - Production o ...

Oracle Parallel in impdp

I have started impdp job in parallel set to 8. I attached to the job with impdp and ordered the status command. The output from command showed that only one worker is working, although parallel was set to 8. Is everything ok? Can I force other workers to execute?Worker 1 Status:State: WORK WAITINGWo ...

Oracle 10.2.0.0 on windows - impdp writes corrupted file when using sqlfile optio

I've been trying to get a DDL script from an oracle export file created using impdp.I tried initially on 10.1, but impdp skipped huge sections of the package bodies.Now, I've tried on 10.2, but impdp still corrupts the various sections by inserting spurious newlines - they seem to be completely rand ...

impdp command returning errors in oracle xe

I am using a CentOS server with Oracle express edition installed on it . I tried to import a dump file with the impdp command and got following list of errors .ORA-39002:ORA-31694: ORA-02354: ORA-39776: ORA-12952:What could be the possible cause for the errors ? Any help will be appreciated . ...

Oracle IMPDP ERROR in 10gR1 ORA-39125

when i try to import smth using impdp i get the following Master table "SYSTEM"."SYS_IMPORT_SCHEMA_02" successfully loaded/unloadedProcessing object type SCHEMA_EXPORT/USERORA-39125: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS while calling DBMS_METADATA.CONVERT []ORA-06502: PL/SQL: numeri ...

Oracle Weird file access problem with impdp/expdp

I've read the docs, I've searched Google and MetaLink. I'm stumped.I'm trying to do an impdp or expdp and keep getting the "ORA-39070: Unable to open the log file." messages. All the docs says that this means your directory isn't valid. Here's the details:SQL> l1* select * from dba_directoriesSQL ...

oracle 10g impdp log didn't catch failed to create FK?

We try to use 10g impdp, the speed was impressive, but we found an issue here:We found some missing FKs after impdp, since all the missing FK point to other schedma which not exist in current instant. Here is an example: ALTER TABLE HR.EMP ADD (CONSTRAINT SGI_FRM_FK FOREIGN KEY (DEPT.ID) REFERENCES ...