access objects existing in a different schema and database (JDBC API)

[Carmen Kwong]

Some parts of this message have been removed. Learn more about Nabble's security policy.

Hello,

I'd to know how to access objects exists in a different schema and database?
I've connected to an Oracle database (using JDBC ODBC Bridge), and using the results from running some queries in this database, I need to access objects (update records in tables, delete records from tables) existing in a different schema and database.

Anyone who could shed some light on this would be very much appreciated!
Thanks a bunch.

Carmen  

---

CDN College or University student? Get Windows 7 for only $39.99 before Jan 3! Buy it now!
------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

[manningr]

Hi Carmen,

If the other schema is in the same Oracle server instance (SID), and you have
privileges to access the schema with the user account that you connected with,
then the objects (tables, views, etc.) should be loaded into the object tree
by default (this can be controlled using the Alias Properties to specify which
schemas are loaded when you connect; right-click on the Alias and
choose "Alias properties").

However, if the other schema is in a different Oracle server instance
(SID), then
you would need to create a new alias to connect to that server intance.

Rob Manning

On Thu, Oct 29, 2009 at 7:17 PM, Carmen Kwong <kawaimimichu@...> wrote:

> Hello,
>
> I'd to know how to access objects exists in a different schema and database?
> I've connected to an Oracle database (using JDBC ODBC Bridge), and using the
> results from running some queries in this database, I need to access objects
> (update records in tables, delete records from tables) existing in a
> different schema and database.
>
> Anyone who could shed some light on this would be very much appreciated!
> Thanks a bunch.
>
> Carmen
>
> ________________________________
> CDN College or University student? Get Windows 7 for only $39.99 before Jan
> 3! Buy it now!
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference
> _______________________________________________
> Squirrel-sql-users mailing list
> Squirrel-sql-users@...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

[Dennis Benzinger]

Hi Carmen!

-------- Original-Nachricht --------
> Datum: Thu, 29 Oct 2009 17:17:34 -0600
> Von: Carmen Kwong <kawaimimichu@...>
> An: squirrel-sql-users@...
> Betreff: [Squirrel-sql-users] access objects existing in a different schema and database (JDBC API)

>
> Hello,
>
> I'd to know how to access objects exists in a different schema and
> database?
> I've connected to an Oracle database (using JDBC ODBC Bridge), and using
> the results from running some queries in this database, I need to access
> objects (update records in tables, delete records from tables) existing in a
> different schema and database.
> [...]

You could create a database link in the Oracle database you connected to.
Then you can access the other database from within the connection to the
first database.


Hope that helps,
Dennis Benzinger

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users