Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle
| Search | Today's Posts | Mark Forums Read
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 23rd, 2004, 10:35 AM
Authorized User
 
Join Date: Sep 2003
Location: , , .
Posts: 83
Thanks: 0
Thanked 0 Times in 0 Posts
Default Using export and import tool for Oracle

Hi everyone,

I have the problem of migrating an Oracle database to a remote machine and I came across the exp and imp utilities in Oracle and I think that it is the best solution for my problems.

I have a few general questions and I am hoping that someone who has had more experience with these tools can give me some pointers:

- I have Oracle 9i installed and I have created 3 databases. However, when I use the export utility it does not ask me which database instance I want to export. If I do a full export would it dump all the three databases in the export dump file?

- Similarly, when using the imp tool on a remote machine, will it create a new database instance automatically based on the schema of the exported database? Will I have to create an empty database forst and import the contents?

Thanks,

Sincerely,

Pankaj

 
Old June 23rd, 2004, 11:04 AM
Authorized User
 
Join Date: Apr 2004
Location: Boise, ID, USA.
Posts: 70
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Are you sure that you have created three database instances rather than three schemas? Oracle schemas are roughly comperable to SQL Server databases.

When you invoke the export utility, you specify the database instance to connect to (i.e. scott/tiger@instance). If you don't specify an instance, the default instance will be chosen.

The import utility will not create a new database instance. It will import the data into an existing database.

Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC




Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem in Import/Export surendraparashar SQL Server 2000 5 November 6th, 2007 01:16 PM
Excel Export then Import problem courtney_ctisn Classic ASP Basics 8 October 18th, 2007 09:57 AM
Still problems with Import / Export needelp Access VBA 1 September 21st, 2006 08:03 PM
How to import & export beetle_jaipur SQL Server 2005 0 September 16th, 2006 04:17 AM
Import/Export Wizard for Oracle 9i, Need Help!!! tarivs ADO.NET 0 January 18th, 2004 04:56 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.