This content has been marked as final. Show 5 replies
Could you please be more specific what you mean with "oracle gateway server". Do you have an Oracle database installed on this machine as well or is it just the Oracle gateway software?
oracle gateway server: Server have Oracle gateway software only. and i'm asking how i can create MV on this server.
or what is the litest oracle instance i can install on it.
You can't create a MView within the gateway itself. The gateway is just a process that handles the connections to a foreign database only works with an Oracle database.1 person found this helpful
So you have to create the MView in your Oracle database (in your 10.2.0.5 db) using the gateway database link to the SQL Server.
When a MView refresh takes a long time it might be related to the amount of records you need to replicate.
you are right,
but th second part of my question is:
what is the smallest type of database i can install it on Oracle Gateway server to create the MV on it, so i can create synonym to MV into oracle database server (10.2.0.5 db)
thanks for your help.
Just to clarify: There's normally no need to install a database on the gateway server. You can create the mview directly in your 10.2.0.5 database.
If you really want to have another database that contains the mview then install on the gateway box the Oracle database using the standard edition. There's no need to activate Enterprise Manager or other stuff.
Regarding the sizing of the memory it really depends on the amount of data you need to pull through the gateway and you want to select using the synonym. So there's no generic answer about the sizing.