Multiple Geodatabase At Oracle

[YudiArdianto]

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

[VinceAngelo]

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

- V

[YudiArdianto]

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

[VinceAngelo]

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

[OvidioRivero]

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_D...

[VinceAngelo]

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

[YudiArdianto]

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