Oracle
Hi frds iam 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.
Iam using windows xp-2, oracle 10g
Software/Hardware used:
xp2
Software/Hardware used:
xp2
ASKED:
August 31, 2012 3:24 PM
UPDATED:
August 31, 2012 3:36 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
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.