• Oracle: How to import schema to replace identical schema but retain unique identifier?

    I have spatial (SDO) data that I would like to import from one schema into another identical schema. My problem is that I only want to replace the spatial data that have the exact same UID_1 (Unique Identifier). Is there a way to do this and if so how?

    OracleATE190 pointsBadges:
  • How to give Oracle user access to another user’s schema

    We have two users in Oracle that were created by running the following commands as SYSDBA from SQL Plus: create user $blah identified by $password; grant resource, connect, create view to $blah; Now we need to give one of those users access to the other user's schema but we're not sure on how to...

    ITKE440,500 pointsBadges:
  • oracle

    how to find the difference between structure of the table?

    GOBIKKANNAN5 pointsBadges:
  • User name and schema name in Oracle 10g

    In Oracle database- Assume that I have logged in as "jaga"(user name). can I use the user name "jaga" with the table name to refer a column. example : select jaga.emp.name from emp where age>100 here jaga is schema name(user name), emp is the table name and name is the column name. can i use the...

    Prcvjr220 pointsBadges:
  • Oracle schema replication in standard edition

    Can anyone please let me know the solution for Oracle schema replication in standard edition?

    Khaliddba50 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.