The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
37 views

RAC, data guard, physical stand by and impdp

We're setting up a RAC 2 nodes data guard 11g environment, with a remote physical standby (2 nodes also) We receive the client's data he exports with expdp. We have imported his dump in the primary ...
0
votes
0answers
70 views

Impdp over DB_LINK failing with ORA-31631

I am getting below error message while trying to execute impdp between our SIT and UAT environments: ORA-31631: privileges are required ORA-39149: cannot link privileged user to non-privileged user ...
0
votes
0answers
529 views

Importing dump file contents to another DB with different schema using Oracle Data Pump

I asked this question in stackoverflow but no one was able to answer it so am trying my luck here if anyone knew what am talking about. Here is the link original question. What i wanted to do is to ...
0
votes
1answer
282 views

Exporting from Oracle enterprise edition to standard edition reaches schemas limit

So, I'm trying to export an oracle database(10.2) from EE to SE over a networklink. It all works fine except that I'm hitting a limit. The database has 1335 schemas and it seems that I can't transfers ...
0
votes
1answer
111 views

Connection problem after a big impdp

This morning i had a weird problem just opening the SQL developer i cannot connect to my database. I checked the log file of the impdp operation launched before (14G), all the data is imported without ...
0
votes
1answer
305 views

Importing Oracle database from dump where source db filesystem has changed

I'm migrating a database from one server to other. In the migration process we changed the filesystem structure from : /appli2/oradata05/HISTO/ /appli2/oradata06/HISTO/ /appli2/oraredolog01/HISTO/ ...
0
votes
1answer
338 views

User creation and rights to import a dump

I'm having problems creating an instance of Oracle 10.2.0.4 and importing a dump from other environment. I'm using Oracle under AIX. I used a ksh script and everything goes right except when creating ...
1
vote
0answers
247 views

Oracle expdp et impdp : order of schemas?

When I try to export and then import many schemas from one Oracle DB to another one, I get errors because grants and synonyms cannot be recreated in the target DB; the reason is probably that the ...
0
votes
1answer
330 views

Export Data Pump all data from few schemas except one table structure only?

we use to make a copy of schemas from one database and move it to another for testing using this par file ... DIRECTORY=EXPORT DUMPFILE=QQS_PROD.DMP LOGFILE=QQS_PROD.LOG ...
-1
votes
1answer
327 views

Importing only one user data from a Dump file

I am using oracle 11gr1 SingleByte Database, I am trying to import a Dump file. but strangely the dump file contains multiple user objects(i.e, Import(IMPDP) is not done properly). example: . . ...
1
vote
2answers
2k views

Oracle impdp - Importing file from remote server

Am I missing something or is it not possible to import a dump (.dmp) file using impdp to a database on another server other than where it was created? All of my investigations lead me to believe that ...
0
votes
3answers
3k views

Exporting schema data (tables, permisions) into another schema on same database

I want to take data from one schema schema1 and put it into schema2 this should be quite easy to do but i have searched through the oracle documentation and can't find a way to do it.
1
vote
0answers
3k views

impdp failing with ORA-01031: insufficient privileges

I'm trying to import a dmp file provided by our dba to my dev database. I've been able to export the contents to a SQLFILE and the contents look ok. I tried importing the schema and it kept on failing ...
3
votes
1answer
1k views

Oracle: Full database (user) restore requires drop?

In our development environment (Oracle 11g), we often have to restore databases (users) to previous versions to test upgrades, verify defects, etc. We are using expdp/impdp to perform our ...
3
votes
1answer
3k views

How to find the schema name of a data pump dmp file?

I have been given a DMP data pump export file to import into my local Oracle instance. I've tried running this command line: impdp full=Y directory=DATA_PUMP_DIR dumpfile=MyDumpFile.dmp ...
5
votes
1answer
21k views

How to transfer data using expdp and impdp commands?

I'm Oracle noob, and my intention is to transfer all data and metadata from one schema to another schema within an Oracle database. I'm planning to use datapump expdp and impdp commands. I have ...
1
vote
1answer
136 views

Importing Oracle database from dump where source dump is spread across different tablespaces

How to import an Oracle schema from a dump file into another schema in new Oracle DB, where the target schema has only USERS and TEMP table spaces where as Source schema is having data distributed in ...
2
votes
3answers
174 views

How can I identify and fix bottlenecks in an Oracle11gR2 import

I've recently been tasked with moving our Oracle 11g database from a linux CentOS desktop to a windows 2008 server. Given I've not done much behind the scenes stuff with oracle before I'm a bit out of ...
0
votes
1answer
2k views

ORA-39083: Object type INDEX_STATISTICS failed to create with error

I am trying to restore Oracle DB from a backup taken recently. While restoring I got the following error: Failing sql is: DECLARE I_N VARCHAR2(60); I_O VARCHAR2(60); NV VARCHAR2(1); c ...
5
votes
1answer
830 views

Trying to copy a schema using impdp

I'm trying to copy a SCHEMA in its entirity using oracle's IMPDP tool. I've setup a database link back to itself and the link works fine. Then I'm running this: impdp ...