"Direct upgrade" refers to using the Database Upgrade Assistant, i.e. an
in-place upgrade. If you have the downtime window to upgrade via a full
export and import, you'll be supported as long as the import utility can
read the export file, which is usually quite a few releases (pretty sure
you can use export & import to go from 7.1 to 10.1).
Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
-----Original Message-----
From: Ryan
[mailto:oracledba-ezmlmshield-x13372426.[Email address protected]
Sent: Tuesday, March 01, 2005 11:53 PM
To: LazyDBA Discussion
Subject: RE: 8i to 9i database upgrade
Justin,
Note:159657.1 (metalink)
Upgrade path for Oracle 8i:
If your old release version is 8.1.5 or 8.1.6, then direct upgrade to
Oracle 9.2
is NOT supported. You must first upgrade this version to 8.1.7. After
the
upgrade to 8.1.7 or your version IS 8.1.7, you can directly upgrade your
database to Oracle 9.2. However, if your target release is 9.0.1,
direct upgrade from 8.1.5 and 8.1.6 is supported.
Does this mean that it is the process that is not supporte dor what, and
if
it is the process that is not supported how can they then support
theresult
?
R
|---------+--------------------------------------------------------->
| | "Justin Cave (DDBC) " |
| | <oracledba-ezmlmshield-x53321294.[Email Address Removed] | azyDBA.com> |
| | |
| | |
| | |
| | 02/03/2005 11:57 AM |
| | |
|---------+--------------------------------------------------------->
>-----------------------------------------------------------------------
----------------------------------------|
|
|
| To: "LazyDBA Discussion" <[Email address protected]
|
| cc:
|
| Subject: RE: 8i to 9i database upgrade
|
>-----------------------------------------------------------------------
----------------------------------------|
I'm not sure where you read the particular comment about supported
upgrades, but I'm pretty confident that it refers to using the Database
Upgrade Assistant. Going from 8.1.6 to 9.2.0 via export and import is
certainly supported.
Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
-----Original Message-----
From: Ryan
[mailto:oracledba-ezmlmshield-x77187216.[Email address protected]
Sent: Tuesday, March 01, 2005 9:23 PM
To: LazyDBA Discussion
Subject: RE: 8i to 9i database upgrade
Thanks but doesnt really answer my question.
What I am trying to find out is what Oracle will support. Is it the
process
of the full import export that they wont support or is it the system
once
you have upgraded it by a full imp/exp.
I have posted a question to oracle on metalink but they dont seem to be
to
quick to commit them selves to an answer.
R
|---------+--------------------------------------------------------->
| | "Ramekar Mahesh " |
| | <oracledba-ezmlmshield-x72406025.[Email Address Removed] | azyDBA.com> |
| | |
| | |
| | |
| | 02/03/2005 10:16 AM |
| | |
|---------+--------------------------------------------------------->
>-----------------------------------------------------------------------
------------------------|
|
|
| To: "LazyDBA Discussion" <[Email address protected]
|
| cc:
|
| Subject: RE: 8i to 9i database upgrade
|
>-----------------------------------------------------------------------
------------------------|
Better to create a new oracle 9i database and put the data in.
-----Original Message-----
From: Ryan
[mailto:oracledba-ezmlmshield-x31329470.[Email address protected]
Sent: Wednesday, 2 March 2005 12:17
To: LazyDBA Discussion
Subject: 8i to 9i database upgrade
Can some one please clear something up for me.
When doing a direct upgrade from 8.1.6.3 to 9.2.0.5 and you do a FULL
export and import, what is it that Oracle WONT support ?
On metalink they say that for a supported system you need to go to 8.1.7
or
9.1 first. So do they mean that they will not support the process of you
do
a direct upgrade or do they mean they will not support the updated
database
if you do a direct upgrade.
Thanks
R
________________________________________________________________________
____
___
Unencrypted electronic mail is not secure and may not be authentic.
If you have any doubts as to the contents please telephone to confirm.
This electronic transmission including any attachments is intended only
for those to whom it is addressed. It may contain copyright material or
information that is confidential, privileged or exempt from disclosure
by
law.
Any claim to privilege is not waived or lost by reason of mistaken
transmission
of this information. If you are not the intended recipient you must not
distribute or copy this transmission and should please notify the
sender.
Your costs for doing this will be reimbursed by the sender.
We do not accept liability in connection with computer virus, data
corruption,
delay, interruption, unauthorised access or unauthorised amendment.
________________________________________________________________________
____
___
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html
________________________________________________________________________
_______
Unencrypted electronic mail is not secure and may not be authentic.
If you have any doubts as to the contents please telephone to confirm.
This electronic transmission including any attachments is intended only
for those to whom it is addressed. It may contain copyright material or
information that is confidential, privileged or exempt from disclosure
by law.
Any claim to privilege is not waived or lost by reason of mistaken
transmission
of this information. If you are not the intended recipient you must not
distribute or copy this transmission and should please notify the
sender.
Your costs for doing this will be reimbursed by the sender.
We do not accept liability in connection with computer virus, data
corruption,
delay, interruption, unauthorised access or unauthorised amendment.
________________________________________________________________________
_______
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html
________________________________________________________________________
_______
Unencrypted electronic mail is not secure and may not be authentic.
If you have any doubts as to the contents please telephone to confirm.
This electronic transmission including any attachments is intended only
for those to whom it is addressed. It may contain copyright material or
information that is confidential, privileged or exempt from disclosure
by law.
Any claim to privilege is not waived or lost by reason of mistaken
transmission
of this information. If you are not the intended recipient you must not
distribute or copy this transmission and should please notify the
sender.
Your costs for doing this will be reimbursed by the sender.
We do not accept liability in connection with computer virus, data
corruption,
delay, interruption, unauthorised access or unauthorised amendment.
________________________________________________________________________
_______
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page