topic Re: Multiple Geodatabase At Oracle in Data Management Questions

Multiple Geodatabase At Oracle

YudiArdianto — Thu, 22 Jul 2010 08:21:49 GMT

Some one can help me...

I just create a multiple geodatabase at oracle at same SID (ex:ORCL) as usual there is one SDE schema at ORCL, it is possible to create more than one SDE schema at same ORCL ? cause iwant to create replica at the same ORCL

Regards

Yoe

Re: Multiple Geodatabase At Oracle

VinceAngelo — Thu, 22 Jul 2010 11:03:38 GMT

No, this is not possible. Multiple repositories require muliple Oracle instances.

- V

Re: Multiple Geodatabase At Oracle

YudiArdianto — Fri, 23 Jul 2010 01:08:20 GMT

No, this is not possible. Multiple repositories require muliple Oracle instances.

- V

Dear Mr.Vangelo

Thanks for your answer, i'm just curious about that matter because i have limited orale license to create another instance, or there are another solution to replica geodatabase at one instance.

Yoe

Re: Multiple Geodatabase At Oracle

VinceAngelo — Fri, 23 Jul 2010 10:08:38 GMT

Creating two replicas in one database instance would be possible with any of the
other DBMSes supported with ArcSDE, but Oracle uses a differrent container model
and cannot be used in this manner. If cost is the issue, you should look at using
open-source PostgreSQL instead.

- V

Re: Multiple Geodatabase At Oracle

OvidioRivero — Fri, 23 Jul 2010 13:14:36 GMT

I don't know if you are still watching this thread but you could create a schema geodatabase. This is supported in Oracle. That puts another SDE schema on the database and you can create whole other arcsde GDB.

Take a look at this.

http://webhelp.esri.com/arcgisdesktop/9.2/index.cfm?TopicName=Using_multiple_geodatabases_within_a_DBMS&anchor=usdesc

Re: Multiple Geodatabase At Oracle

VinceAngelo — Fri, 23 Jul 2010 14:44:29 GMT

User schema geodatabases do not create another SDE schema. They create parallel ArcSDE tables
in a different schema, which work in concert with (but apart from) the existing SDE schema's tables.

- V

Re: Multiple Geodatabase At Oracle

YudiArdianto — Mon, 26 Jul 2010 00:52:38 GMT

Hi all

Thanks for the answer and solution, i will consider to use PostgreSQL to make replication or another DBMS to create a replication.

Regards

Yudi