Where will Oracle databases be stored in my system?

660 pts.
Tags:
Java
Oracle 10g
Hi friends, I'm using the database Oracle 10g and I did my mini project in Java. And it is a web based application. My project is done by some other company just make use of the code developed by them. In that they used the type-1 driver to connect with the database. I had the code in java (jsp) .I haven’t construct any data base to my project. But there is a file with the extension of (.dmp) when I import the dump file automatically the tables are created or inserted into my database. What’s my question is now I want to build a project in my own system or computer and I want to execute that project in other system with the help of database if I create a user named “eti” and password “eti”. I want to know where these databases stored in my system. And how can I search for those (.dmp) or (.sql) file in my system where it is going to store. I'm using windows xp-2, oracle 10g

Software/Hardware used:
xp2
ASKED: August 31, 2012  3:24 PM
UPDATED: August 27, 2013  3:00 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    An Oracle database is not stored in a single file by default.  The database is composed of control file(s), data files(s), redo log file(s), etc.  To create a DMP file that includes everything you could need to re-create the database on another system, you need to use the EXPORT utility.  There are also some others tools that could help you create a SQL script with all of the commands needed to re-create all of your objects and insert the appropriate data into them.
    65,110 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following