Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Creating a Database from the .dmp file

525266Feb 7 2011 — edited May 9 2011
I am a novice in Oracle Technology. My problem is as follows:

I have Oracle Database 10gR2 software installed on a Windows server 2003 (with Service Pack 2) machine in the local network. The Oracle instance name is 'T27'. The 'T27' instance is reading a database. This instance and database has been created by a person previous to me.

My requirement is to have another instance by the name, say 'T28', and this new 'T28' instance is to read another new database (different from the existing one) that I will be creating.

Specifically:

[1] How do I create an Instance with the Oracle Database 10gR2 server software?
[2] How do I create a separate database with the Oracle Database 10gR2 server software?
[3] How do I make this newly created Instance read the newly created database?

Additionally I have a '.dmp' file available with me. This was the backup copy of a database take by the person before me.

[4] How do I create a new database from the '.dmp' file?


// Please note that there already exist an instance and a database in the current installation.
// I want to add an instance as well as a new database.
// The database is to be created from the .dmp file.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 6 2011
Added on Feb 7 2011
6 comments
4,268 views