Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Location
    Hong Kong
    Posts
    5

    Unanswered: cross tablespaces

    How to cross different tablespaces in a select statement?

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: cross tablespaces

    Originally posted by frankkot
    How to cross different tablespaces in a select statement?
    Do you mean different schemas, or databases? Tablespaces are irrelevant to a select statement.

    If you mean schemas, then it is simply:
    SELECT a.*,b.*
    FROM tablea, schema2.tableb
    WHERE...;

    where "schema2" is the name of another schema than the one you are in.

    If you mean databases, then you would use a database link. Once a database link exists, you can refer to it in a select statement:
    SELECT a.*, b.*
    FROM tablea a, tableb@dblinkname
    WHERE ...;

Posting Permissions

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