1
vote
1answer
23 views

Oracle error 12154 while importing DMP file

My Setup I'm running Windows 7 64-bit, using Oracle DB 11g R2 for Windows 64-bit. I have Oracle SQL Developer Release 3.0 (4.0.2.15.21) as the GUI for my database. Question I followed the ...
0
votes
0answers
34 views

How best to export from Oracle Ent Ed (EE) to Oracle Express Edition (XE)?

I am aware that Oracle Ent Ed (EE) has more functionality than Oracle Express Ed (XE). But I would like to do a FULL export from EE to XE. Is this even possible? The only solution I can assume will ...
0
votes
1answer
33 views

Why is it necessary to type “host” before the imp command when I'm using SQL*Plus to import a dmp file into Oracle?

In SQL*Plus, I'm connected to an Oracle 11g database. When I type imp help=y It gives me SP2-0042: unknown command "imp help=y" - rest of line ignored. But when I type host imp help=y it ...
0
votes
1answer
141 views

Export, based on query, into INSERT text file

I need to export some data into a file. The data are selected with a query that will often be made of multiple joins. I want the import operation to be as easy as possible. I was thinking of building ...
1
vote
0answers
2k views

Importing a different character set export dump into another DB instance

I am trying to import a given dump file using oracle imp utility. However; I am facing the following issues. C:\Users\AD>imp DB_USER/*****@dev1 file=C:\test\db42312.dmp log=C:\test\import2.log ...
1
vote
0answers
170 views

Importing bulk csv file to oracle database

I am going to import a bulk csv file to oracle database. This file contains around 200m records. I was wondering what is the best way of importing this file? I check the performance of SQL developer ...
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
2answers
265 views

Where .dmp file is restored after import in oracle?

I am new to oracle and I have abc.dmp file at c:\abc.dmp location. I want to import this abc.dmp file. I am using the following command. c:\>imp system/mypassword file=c:\abc.dmp full=y I am ...
0
votes
1answer
105 views

How to export oracle 11g database partially

I have a huge oracle test database whose size is more than 100 GB. I want to export only 1% of all the data and import it into my local database to have a local replica of that application. Is it ...
0
votes
0answers
69 views

Viewing tables and data from a tablespace that was attached from another database

I'm using a database Oracle 11g. I have a DBF file of an old tablespace from a different database that I want to connect to the existing database. I've created a tablespace with REUSE caluse, and it ...
1
vote
1answer
709 views

Creating a USER using the imp command [duplicate]

I was told I can use exp to export a certain USER, then DROP the user and with the imp command I can recreate that USER with all of its tables. Is it true? How do I do it? I already have an ADMIN ...
0
votes
0answers
138 views

Efficient, up-to-date way to import an Oracle database into MySql

Here's the situation: I need to automatically merge data from an Oracle and a MySql server into a single, new MySql server. The merging will happen daily, and the resulting server will be hosted on a ...
0
votes
0answers
284 views

How to clone a database from one environment to a database on another environment?

OS: RHEL DB: Oracle 11g version 11.1.0.7.0 I am trying to clone a database on one environment (environment A) to another database on a separate environment (Environment B). Environment B's database ...
0
votes
1answer
449 views

Exporting and importing a database

I have setup an Oracle 11g Database and have a question about exporting and importing a database. I am using Enterprise Manager and have browsed to the following: Data Movement->Export to Export ...
0
votes
2answers
859 views

Oracle schema import is not importing all the tables present in the schema dump file

I have exported an existing oracle schema from another machine and then imported it in my local machine. Import was successful, but some tables which are present in the export dump file are not ...
4
votes
1answer
2k views

Update oracle sql database from CSV

I tried google at first but no luck. Is it possible to update tables from csv file? I am using SQL developer and I am using a script to export edited rows to a csv file. I would like to update the ...
1
vote
1answer
3k views

Oracle 10g dump file into Oracle 11g database

I went through this link for my answer to the same question. I was not sure if i could continue in the same link, so created a new question. Oracle 10g dump file push into Oracle 11g database Sorry ...
0
votes
1answer
189 views

Does a standby slow down Oracle imp?

I have Oracle 10gR2 installed on Redhat Linux 5.4 on two servers (primary and physical standby). When I import data into the primary server while the standby is started it takes too long to complete ...
0
votes
2answers
110 views

How to create two database copies in two users from same dump file

I have a database dump file with me, I need to make two copies of the database using the same dump file in two users. Is it possible?
0
votes
1answer
490 views

Oracle not trusting statistics after an import?

We are seing some strange behavior in the way Oracle is handling statistics of an imported schema. We build a schema on the dev system, analyze if and import into the production with the stats. For ...
0
votes
1answer
1k views

Oracle Imp Dump Full

Can I create a new instance in a new server and import a dump file which was made with the command exp full=y etc? If it is possible do I need to recreate tablespaces and users before the import? If ...
0
votes
2answers
625 views

Oracle dump import

After a system failure I bought a new server and now I'm trying to recreate the Oracle database I had. I have a dump file which was made with the command exp and full=y. Can I restore the full ...
1
vote
1answer
216 views

Imports & exports under storage constraints and preallocations

I have a 5GB oracle database that I want to export and then import on my own local database. Easy right? The point is, I use oracle XE 10g which allows me to use up to 4GB. I then decided to make the ...
5
votes
1answer
12k views

Importing schema to new or different tablespace

Is there a convenient way to import a schema into Oracle 11gR2 using a single new or different tablespace than where the data originated? As an example, I have exported BLOG_DATA from OLDDB, where ...
0
votes
1answer
757 views

Getting error when using Oracle imp command to import dmp file

I am importing a dmp file using the following command: imp user/pass file=file.dmp log=logfile.log full=y ignore=y destroy=y I get the following errors: . . importing table ...
3
votes
2answers
1k views

Can you time how long an Oracle import takes?

I'm on a Windows machine with Oracle Client 11.1.0, and am going to import a database dump. I'm importing from the command line with the "imp" command. Is there an option to time how long the import ...
2
votes
0answers
5k views

Oracle 11g .DMP viewer

I have received a dump of a Oracle 11.2.0.2.0 db, which I'd like to export to some readable format like plain text, CSV, excel... Is that possible in some sort of a simple way? I've found a few ...
0
votes
1answer
390 views

Unable to restore database in Oracle 10g

I created a database backup using the expdp command in Oracle 10g. The backup appears to be created successfully. However, while restoring using impdp command I get the following error message. ...
2
votes
2answers
2k views

Materialized View does not import properly when importing a db for a second time in another schema

When I import a database with materialized view mv_mt in just one schema I get no errors. create materialized view mv_mt refresh complete next trunc( sysdate ) + 1 as SELECT sysdate, media_type.* ...
1
vote
1answer
392 views

When using expdp to create a snapshot of an oracle schema, how do I ensure that no post-export additions are retained upon using impdp to revert?

I want to create a snapshot of an Oracle schema that I can revert back to after testing. Impdp and expdp seem to be the best fit as far as how I'd like to accomplish it, but the problem is that impdp ...
2
votes
1answer
1k views

ORA-12899: importing a .dmp file + character set conversion

I'm working on a django project on Ubuntu 10.04 with Oracle Database Server , so I've installed: Oracle Database 10g xe universal Rel.10.2.0.1.0 cx_Oracle-5.0.4-10g-unicode-py26-1.x86_64 When I ...
1
vote
1answer
2k views

Best practices for ensuring up to date sequences after table import

We perform weekly table moves between several schema using expdp and impdp. Some tables have sequences associated with the ID columns and I'd like to ensure that the sequences are always up to date on ...
1
vote
1answer
3k views

restore database from dmp file

I have a situation: I have a dmp file and a database with old data server crashed and the latest data we have ar in the dmp file! we managed to pull the server back but it has old data! so we need to ...
4
votes
3answers
4k views

Import Oracle full dump file to fresh Oracle installation

I am importing a Oracle dump fill created on a AIX Oracle 9.2 installation with a Full Export option to a Windows Oracle 10.2.0.4 on Windows 2008 R2 x64. I want to import the file to a clean ...
1
vote
3answers
551 views

How to find out which data I just imported into Oracle?

I imported two dump files (no idea what they contained, my goal is precisely to find out what they contain) into Oracle, but now I am struggling to identify what is the data I imported, and what data ...
2
votes
3answers
2k views

Oracle “Import from Export Files” screen refusing both SYSADMIN and Normal users

I have just installed Oracle 11g on Win64, and I want to import some .dmp files. I am trying with the tool Oracle Enterprise Manager 11g: If I log in with SYS as SYSADMIN, and go to Import from ...
0
votes
1answer
2k views

Import .pde file on PL/SQL Developer

How can I import my .pde file which I already exported from another database by PL/SQL Developer?
4
votes
1answer
10k views

Create dump file using Oracle SQL Developer

I think I'm missing a simple point, but I couldn't find a way to use Oracle export (exp/expdp) and Oracle import (ipm/impdp) with Oracle SQL Developer (version 1.5.5)? Is there a way for it? If ...
2
votes
1answer
969 views

Use sqlldr control file to automatically create several tables in Oracle

I have a client who has a requirement that I load data from csv files into an Oracle database. Part of the requirement is that I use sqlldr and provide a control file to facilitate loading this data. ...
2
votes
1answer
2k views

Eliminate database fragmentation (export, drop and re-import tables)

I have one datafile that is highly fragmented. Its size is 10GB now and real size that is used is 2.5GB,so 7.5 is free. I decided to export data, drop that datafile, recreate it and import data. ...
6
votes
2answers
4k views

How to extract Procedure, Function, etc. Source Code from an Oracle Export

I have generated an EXPDAT.DMP file of an Oracle database with the command: exp userid=usr/pass@db owner=own rows=n compress=n I then ran the following command to generate a file containing the ...
3
votes
1answer
10k views

How can I import the contents of an Oracle database into Visio to create an Entity Relationship Diagram?

I have an Oracle database, and I would like to create an ERD in Visio 2007 Pro. I have so far looked at DBMS_METADATA.GET_DDL commands to generate ddl. I know that I can import an Access DB into ...
13
votes
7answers
35k views

Import a Oracle DMP file into a Fresh install of oracle

A client sent us a oracle database we need to test against. We don't use oracle or have any oracle expertise in house. We need to setup the database so we can connect to it and debug a problem. I ...