Home » Other » General » Database structure from Dump
Database structure from Dump [message #103908] Thu, 13 May 2004 00:01 Go to next message
sundas
Messages: 1
Registered: May 2004
Junior Member
i m new to oracle
i have a dmp file of some oracle database
but i don't know in
this file wht are the contents ie(tables,views etc)

Can any one tell me how to use
this dump file

to make its schema objects

using any tool
regards
Re: Database structure from Dump [message #103949 is a reply to message #103908] Mon, 31 May 2004 05:43 Go to previous messageGo to next message
Tak Tang
Messages: 142
Registered: May 2004
Senior Member
The oracle import tool 'imp' has an option to generate SQL to create the schema objects, instead of loading the data.

For help, do 'imp' without any options.

You'll need to run it with the 'ROWS=NO' to avoid actually loading data, and 'INDEXFILE=' to save the generated script.

Takmeister
Re: Database structure from Dump [message #104217 is a reply to message #103949] Mon, 23 August 2004 02:08 Go to previous messageGo to next message
Avra Adhya
Messages: 7
Registered: August 2004
Junior Member
Hi... You can see it by using a software called Easy Dump For Oracle...You may get it in the follwing link....www.soft32.com/download_47107.html
Re: Database structure from Dump [message #104712 is a reply to message #103908] Fri, 07 January 2005 00:35 Go to previous message
drkraju
Messages: 1
Registered: January 2005
Junior Member
hai
object:
how to convert .dmp files into other data bases.
ie: from oracle to foxpro and to access.
i am new to work with oracle dump files that is *.dmp file.can you give me the structure of it and how they usefull to convert data from one data base to another.
Previous Topic: DBMS Ofuscation Tool Kit
Next Topic: Dual Table Name
Goto Forum:
  


Current Time: Fri Dec 09 19:27:49 CST 2022