| Database structure from Dump [message #103908] |
Thu, 13 May 2004 00:01  |
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  |
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 #104712 is a reply to message #103908] |
Fri, 07 January 2005 00:35 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
