Import from 10g backup to 9i DB [message #537789] |
Sat, 31 December 2011 02:49 |
mahmud732
Messages: 82 Registered: October 2009 Location: Dhaka
|
Member |
|
|
Dear All,
I have a backup of Oracle Database 10g (business_bk.dmp). Now I would like to import it into Oracle DB 9i. Is It possible.
If Possible then How?
Please Help me.
Regards
Mahmud
|
|
|
|
Re: Import from 10g backup to 9i DB [message #537792 is a reply to message #537789] |
Sat, 31 December 2011 03:02 |
John Watson
Messages: 8962 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
I operate a one-man campaign trying to explain that an export (which I assume is what you have, from the .dmp filename suffix) is NOT a backup. I even blogged about it here a year or so ago. But never mind that.
You may be able to import into a 9i database, but some objects might fail. What happens when you try it?
[Updated on: Sat, 31 December 2011 03:03] Report message to a moderator
|
|
|
|
Re: Import from 10g backup to 9i DB [message #537857 is a reply to message #537855] |
Mon, 02 January 2012 01:20 |
|
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
From the documentation:
Quote:
An export file is an Oracle binary-format dump file that is typically located on disk or tape. The dump files can be transferred using FTP or physically transported (in the case of tape) to a different site. The files can then be used with the Import utility to transfer data between databases that are on systems not connected through a network. The files can also be used as backups in addition to normal backup procedures.
From my point of view: when you have a proper backup, if anything goes wrong with your database, you can easily restore it. If you don't really care about datafiles, controlfiles, etc. etc. - for example, you are running an XE edition and use only Scott's schema for your own purposes - for example, testing your (PL/)SQL skills and such, an export file might be just "enough". If your disk crashes or whatever happens to the database, XE is easily reinstalled (*) and you'd then simply import your Scott's schema back.
________________________
(*) As we all know, this is not always true. We've seen people struggling with XE installation rather often.
|
|
|
|
|
Re: Import from 10g backup to 9i DB [message #537862 is a reply to message #537858] |
Mon, 02 January 2012 03:13 |
Database admin
Messages: 365 Registered: September 2006 Location: india
|
Senior Member |
|
|
John/Little
Thank you for your wonderful explanations.
Quote:A backup is a copy of datafiles, an export is a copy of data segments
I agree with your words.But did you also mind to see the comments from Sriram and Others in the link you provided who disagree with your words.
Can you clarify their comments ?
[Updated on: Mon, 02 January 2012 03:17] Report message to a moderator
|
|
|
|
Re: Import from 10g backup to 9i DB [message #537871 is a reply to message #537863] |
Mon, 02 January 2012 05:26 |
|
ramoradba
Messages: 2457 Registered: January 2009 Location: AndhraPradesh,Hyderabad,I...
|
Senior Member |
|
|
@ balaji
Read my comments again,
Quote:What My intension is to say that Each tool/Utility has its own priority .
Re read what John Posted on different situations for Recovery/Restore....
Your current Question(hope it is) is
Quote:I have a backup of Oracle Database 10g (business_bk.dmp). Now I would like to import it into Oracle DB 9i. Is It possible.
If Possible then How?
Michel has already answered your Question.
Quote:Quote:
I have a backup of Oracle Database 10g (business_bk.dmp).
This is NOT a backup of your database, this is a dump of it.
Quote:
Now I would like to import it into Oracle DB 9i. Is It possible.
If it has been exported with exp version 9i.
Regards
Michel
Please do not post multiple different question on 1 topic.
Sriram Sanka
|
|
|