DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: two copies of same user schema in one DB?

  1. #1
    Join Date
    Apr 2001
    Posts
    257

    two copies of same user schema in one DB?

    This may sound weird but:

    I have a DB user called A, which owns a set of objects. Corresponding to it, I have a Java application that has many queries using A. when referencing to A's objects.

    Another user is trying to use a copy of the Java application from his own development machine connecting to a "copy" of A's schema _in_the_same_DB_. So whatever changes he has made to his copy of A's schema via his own Java application won't affect the original person's A's schema.

    Requirements:
    - Both A and A's "copy" must be in the same DB
    - Since the Java application has A. all over the place for SQL queries, we are reluctant to go through all the SQL statements to change A to some other DB user. That is, we don't want to change the Java application itself to have it point to a different user's schema which contains the same data as A's.

    Is there a possible solution to this problem?

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    use alter session change current_schema

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width