I thought it was easier to do a fresh install of Oracle 10G and then migrate the 8.1.7 database to Oracle 10G.
-----Original Message-----
From: Carlos Barrera
[mailto:oracledba-ezmlmshield-x863839.[Email address protected]
Sent: Tuesday, November 29, 2005 10:07 AM
To: LazyDBA Discussion
Subject: RE: Rép. : RE: Migrating from Oracle 8.1.6 to Oracle
10g..URGENT
is it possible to do the export with 8 and the import with 10. if so, it's
better to do a fresh install of 10g instead of migrating. or not?
-----Original Message-----
From: Edwards Ed
[mailto:oracledba-ezmlmshield-x59093958.[Email address protected]
Sent: Tuesday, November 29, 2005 9:00 AM
To: LazyDBA Discussion
Subject: RE: Rép. : RE: Migrating from Oracle 8.1.6 to Oracle
10g..URGENT
There is a wizard to convert Oracle 8.1.6 to 8.1.7. There is also a wizard
to convert 8.1.7 to Oracle 10G.
-----Original Message-----
From: Pascal VILTARD
[mailto:oracledba-ezmlmshield-x31109653.[Email address protected]
Sent: Tuesday, November 29, 2005 7:48 AM
To: LazyDBA Discussion
Subject: Rép. : RE: Migrating from Oracle 8.1.6 to Oracle 10g..URGENT
Hi Edwards,
You have an wizard to convert 8.1.7 to 10.2.
Be aware if you change the national caracter set and use other
language.
The size of column may be larger. The wizard notices it.
Pascal Viltard.
>>> "Edwards Ed "
<oracledba-ezmlmshield-x92525136.[Email address protected] 29/11/2005
13:36 >>>
I agree.
-----Original Message-----
From: Trupti Panigrahi
[mailto:oracledba-ezmlmshield-x82068199.[Email address protected]
Sent: Tuesday, November 29, 2005 7:33 AM
To: LazyDBA Discussion
Subject: RE: Migrating from Oracle 8.1.6 to Oracle 10g..URGENT
hi bibhudatta,
i guess you should export using the utility of 10g
login to the 10g server, connect to the 8 instance and export the
data..
Importing it later using imp utility of 10g wouldnt give version
errors...
I hope this helps.
Thanx.
trupti panigrahi
-----Original Message-----
From: Bibhudatta
[mailto:oracledba-ezmlmshield-x57476048.[Email address protected]
Sent: Tuesday, November 29, 2005 6:04 PM
To: LazyDBA Discussion
Subject: RE: Migrating from Oracle 8.1.6 to Oracle 10g..URGENT
Hi Edwards,
But if I am doing it through Export & Import then isn't it possible
that
I can take the export from 8.1.6 & then import it to 10g directly?
Wont
it allow the import stating the version problems??
Thanx & Regards,
Bibhudatta Jena
-----Original Message-----
From: Edwards Ed
[mailto:oracledba-ezmlmshield-x7666516.[Email address protected]
Sent: Tuesday, November 29, 2005 5:48 PM
To: LazyDBA Discussion
Subject: RE: Migrating from Oracle 8.1.6 to Oracle 10g..URGENT
Yes, you must upgrade to 8.1.7 first. Then upgrade to Oracle 10G.
-----Original Message-----
From: Bibhudatta
[mailto:oracledba-ezmlmshield-x11842384.[Email address protected]
Sent: Tuesday, November 29, 2005 7:21 AM
To: LazyDBA Discussion
Subject: Migrating from Oracle 8.1.6 to Oracle 10g..URGENT
Hi Everybody...
I have a production database which runs on Oracle 8.1.6 & Windows 2000
server.
Now the plan is to upgrade the version to Oracle 10g & the operating
system to Linux 4.0. But the knowledge that I have gathered regarding
this is , we can not migrate directly from Oracle 8.1.6 to Oracle 10g.
There has to be an intermediate step to be taken in the whole process.
I
mean to say , we may need to migrate first to Oracle 8.1.7 or some
other
higher version and then we can migrate to 10g. Is this true ?? Has
anyone of you ever faced a similar kind of situation ?? Can anyone
suggest something??
Now if the Intermediate step ( Migrating to 8.1.7 or higher ) is true
then can anyone tell me if this will add more sense if I first migrate
to
Oracle 9i & then from 9i to Oracle 10g ? Will this process save some
time & reduce some risks?? And Will there be any advantages if I
follow
the process of 8.1.6 >> 9i >> 10g rather than 8.1.6 >> 8.1.7 >> 10g.
Please take into consideration that the whole migration will happen in
the new LINUX operating system.
Hope someone among us must have worked in this sort of a situation
before..
Waiting for a response from all of you.
Thanx & Regards,
Bibhudatta Jena
Tel:- +91-22-56685253
-----Original Message-----
From: Gunasekaran Srinivasan
[mailto:oracledba-ezmlmshield-x95778961.[Email address protected]
Sent: Tuesday, November 29, 2005 2:14 PM
To: LazyDBA Discussion
Subject: Urgent help on Table() with PL/SQL Type.
Hi all,
My requirement is - I'll be getting comma separated string as
parameter
in my procedure and I need to
insert each word (delimited by comma) as a row into a table.
I'm trying to achieve it by using PL/SQL Table function with a PL/SQL
Table type.
Here is my Procedure.
Procedure prc_ins
is
array_roll tname := tname ('ABCD', 'XYZ'); -- tname is the type
created in database.
begin
insert into tmp select * from TABLE( cast ( array_roll as tname )
);
end;
the above procedure is working fine. But I would like to replace the
('ABCD', 'XYZ') values by a parameter
and declaring the type TNAME in the package header without creating it
in Database like below.
Procedure prc_ins (str)
is
array_roll tname := tname str; -- tname is the type created in
database.
begin
insert into tmp select * from TABLE( cast ( array_roll as tname )
);
end;
Please let me know if there is a way to achieve this
Thanks/rgds
Guna
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
--------
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
DISCLAIMER:
This message contains privileged and confidential information and is
intended only for the individual named.If you are not the intended
recipient you should not disseminate,distribute,store,print, copy or
deliver this message.Please notify the sender immediately by e-mail if
you have received this e-mail by mistake and delete this e-mail from
your system.E-mail transmission cannot be guaranteed to be secure or
error-free as information could be
intercepted,corrupted,lost,destroyed,arrive late or incomplete or
contain viruses.The sender therefore does not accept liability for any
errors or omissions in the contents of this message which arise as a
result of e-mail transmission. If verification is required please
request a hard-copy version.
--------
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
DISCLAIMER:
This message contains privileged and confidential information and is
intended only for the individual named.If you are not the intended
recipient
you should not disseminate,distribute,store,print, copy or deliver
this
message.Please notify the sender immediately by e-mail if you have
received
this e-mail by mistake and delete this e-mail from your system.E-mail
transmission cannot be guaranteed to be secure or error-free as
information
could be intercepted,corrupted,lost,destroyed,arrive late or incomplete
or
contain viruses.The sender therefore does not accept liability for any
errors or omissions in the contents of this message which arise as a
result
of e-mail transmission. If verification is required please request a
hard-copy version.
--------
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
--------
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
!DSPAM:438c4935245465833372605!
--------
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
--------
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