Home » Server Options » Replication » Creation of Materialized view from oracle 10g - 8i (merged) (oracle 10g)  () 1 Vote
Creation of Materialized view from oracle 10g - 8i (merged) [message #550032] Thu, 05 April 2012 07:11 Go to next message
sathik123
Messages: 37
Registered: December 2010
Location: chennai
Member
Hi
We have the task to create to Materialized view from oracle 10g to 8i.
- Will we face any kind of issue after creation of Materialized view.
Please help me to check what the prerequisite need to be verified is.

Regards
I.Amzath khan
Re: creating Meterialized view from oracle 10g - 8i database [message #550035 is a reply to message #550032] Thu, 05 April 2012 07:36 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Do you mean you want to create a materialized view in a 10g DB that selects data from an 8i DB via a DB link?
Re: creating Meterialized view from oracle 10g - 8i database [message #550038 is a reply to message #550032] Thu, 05 April 2012 07:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do NOT multipost your question in several (sub)forum.

Regards
Michel
Re: Creation of Materialized view from oracle 10g - 8i [message #550039 is a reply to message #550032] Thu, 05 April 2012 07:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The best way is to test it by yourself and ask Oracle and to NOT rely on an answer from a forum.
Anyway, the first thing should be to upgrade to supported versions.

Forgot to mention, 8i does not talk with 10g, this should close the case.

Regards
Michel
Re: creating Meterialized view from oracle 10g - 8i database [message #550045 is a reply to message #550035] Thu, 05 April 2012 08:22 Go to previous messageGo to next message
sathik123
Messages: 37
Registered: December 2010
Location: chennai
Member
Yes, Correct I want to create a materialized view in a 10g DB that selects data from an 8i DB via a DB link.


(Apology for Multi post, Session came out while upload. I didn't know it already uploaded)
Re: creating Meterialized view from oracle 10g - 8i database [message #550046 is a reply to message #550045] Thu, 05 April 2012 08:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I want to create a materialized view in a 10g DB that selects data from an 8i DB via a DB link.


But you can't.

Regards
Michel
Re: creating Meterialized view from oracle 10g - 8i database [message #550062 is a reply to message #550046] Thu, 05 April 2012 12:19 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You might do that if you have 9i somewhere, available to you. Then you'd make two hops:
Oracle 8i <-- DB link --> Oracle 9i <-- DB link --> Oracle 10g
Re: creating Meterialized view from oracle 10g - 8i database [message #566117 is a reply to message #550062] Tue, 11 September 2012 07:19 Go to previous message
sathik123
Messages: 37
Registered: December 2010
Location: chennai
Member
it was very helpful..
Previous Topic: Materialized view housekeeping servicename/dbid
Next Topic: Replicate process abended
Goto Forum:
  


Current Time: Fri Mar 29 07:51:41 CDT 2024