Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Posts
    9

    Question Unanswered: Attaching Tablespace to a database

    Hi,

    I have created a schema on a seperate tablespace(.dbf file). I would like to know if it is possible to attach this schema to another database. For example in SQL Server you can attach the .mdf file and .ldf files to create new database(schema). Is this sort of method possible in oracle and if so how??

    Thank you in advance...

    Sheldon

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    depending on the version you can use transportable tablespace feature ...

    tahiti.oracle.com for the manuals

  3. #3
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Other than a Transportable tablespace... each tablespace is mounted to a given database. If you are looking to be able to view the data in a specific schema from another database, look at db_links ...

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I have created a schema on a seperate tablespace(.dbf file).
    Contrary to the statement above, a schema does NOT "reside" in any particular tablespace. While certain objects owned by the schema may reside in a specific tablespace, some/much of the critical information regarding this schema resides in the SYSTEM tablespace. So the short answer is "NO", you can't do anything close to what you asked about.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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