-
.dmp file restoration
Hi,
I have come across very pitty situation where by i have two .dmp files exported from 10g database. which require to restore at test environment.
now the problem is that neither have user name and password for restore nor any other information related to database.
is there any way to restore the .DMP files on 10g database?
your timely response will be appreiciated
regards
Irfan
-
import dump file you mean?
Use an O/S authenticated account...
sqlplus /nolog
conn sys as sysdba
hit enter
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
contact the DBA who has done the export or check the script used to take the export.
you can also create a sqlfile with the dump available and create the necessary table spaces required. Do you at least know the dump you have is a full db dump or specific schema??
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
Originally Posted by vnktummala
contact the DBA who has done the export or check the script used to take the export.
you can also create a sqlfile with the dump available and create the necessary table spaces required. Do you at least know the dump you have is a full db dump or specific schema??
Thanks,
if it is a full dump, how do i create the sqlfile to re-create the table spaces needed?
the exp was full=y from 8i
but new database machine is 11gr1
-
Originally Posted by fbifido
...how do i create the sqlfile to re-create the table spaces needed?
In unix, to extract the needed ddl to re-create tablespaces/users do this:
PHP Code:
strings <MyDumpFile.dmp >RawDDL.txt
In the resulting file you will find all necessary ddl, unfortunately you may need heavily editing to get executable statements.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
Originally Posted by LKBrwn_DBA
In unix, to extract the needed ddl to re-create tablespaces/users do this:
PHP Code:
strings <MyDumpFile.dmp >RawDDL.txt
In the resulting file you will find all necessary ddl, unfortunately you may need heavily editing to get executable statements.
i have produce the rawddl.txt file, can i upload it to you and let me know how i go about to modify this file so i can re-create the database.
Thank you.
-
Originally Posted by LKBrwn_DBA
In unix, to extract the needed ddl to re-create tablespaces/users do this:
PHP Code:
strings <MyDumpFile.dmp >RawDDL.txt
In the resulting file you will find all necessary ddl, unfortunately you may need heavily editing to get executable statements.
I have done this, now i see allot of things at the begin of each line.
CREATE
ALTER
REVOKE
GRANT
EXECFULL
CONNECT
INSERT
COMMENT
select
these i delete
TABLE
oracle.aurora.*
CALTER TABLE
PROCACTION
ENDSYS
BLOB_COL
CLOB_COL
NLOB_COL
PROCEDURE
FUNCTION
the file size is now 12M after compress it is now 900k
my rawddl.txt
can you have a look and see what i need to re-create my database DCTEST.
Last edited by fbifido; 05-06-2011 at 02:24 PM.
-
Originally Posted by fbifido
if it is a full dump, how do i create the sqlfile to re-create the table spaces needed?
the exp was full=y from 8i
but new database machine is 11gr1
Why don't you start:
1) reading instead of asking this question over and over by hijacking other threads, or
2) put fingers on keyboard and start typing to learn for yourself?
-
Holy cow, quit being a weak sister and try to figure out some things on your own. Read through the file, see a tablespace name, create it on the 11g side and drive on.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|