OraFAQ Forum: Replication » Creation of Materialized view from oracle 10g

Home » Server Options » Replication » Creation of Materialized view from oracle 10g - 8i (merged) (oracle 10g) (

) 1 Vote

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Creation of Materialized view from oracle 10g - 8i (merged) [message #550032]

Thu, 05 April 2012 07:11

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

Report message to a moderator

Re: creating Meterialized view from oracle 10g - 8i database [message #550035 is a reply to message #550032]

Thu, 05 April 2012 07:36

cookiemonster
Messages: 13895
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?

Report message to a moderator

Re: creating Meterialized view from oracle 10g - 8i database [message #550038 is a reply to message #550032]

Thu, 05 April 2012 07:52

Michel Cadot
Messages: 67640
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Do NOT multipost your question in several (sub)forum.

Regards
Michel

Report message to a moderator

Re: Creation of Materialized view from oracle 10g - 8i [message #550039 is a reply to message #550032]

Thu, 05 April 2012 07:55

Michel Cadot
Messages: 67640
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

Report message to a moderator

Re: creating Meterialized view from oracle 10g - 8i database [message #550045 is a reply to message #550035]

Thu, 05 April 2012 08:22

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)

Report message to a moderator

Re: creating Meterialized view from oracle 10g - 8i database [message #550046 is a reply to message #550045]

Thu, 05 April 2012 08:26

Michel Cadot
Messages: 67640
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

Report message to a moderator

Re: creating Meterialized view from oracle 10g - 8i database [message #550062 is a reply to message #550046]

Thu, 05 April 2012 12:19

Littlefoot
Messages: 21647
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

Report message to a moderator

Re: creating Meterialized view from oracle 10g - 8i database [message #566117 is a reply to message #550062]

Tue, 11 September 2012 07:19

sathik123
Messages: 37
Registered: December 2010
Location: chennai

Member

it was very helpful..

Report message to a moderator

Previous Topic:	Materialized view housekeeping servicename/dbid
Next Topic:	Replicate process abended

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 19 10:06:09 CST 2021