Re: How to move tablespace from IASDB to Ora92

Let me see if I can clarify. There are two Oracle instances on our machine: IASDB and OEMREP. The tablespace I want to move is in IASDB and contains only our user data. I want to create an Ora92 database instance and move the tablespace from the application server instance to this new database instance. Once the instance is created, I can export the tablespace and import it into the new instance. I am unsure how to go about creating a new instance, though.. We also have Reports Builder reports defined against the data in this tablespace, and scheduled to run on regular intervals. I'm not sure how to get the reports to point to the tables in th enew database. As I'm writing this, it sounds like it should be fairly straight forward but this is an online system and I don't want to screw it up.

+Les

>
> 9iASR2 involves several repositories - DCM metadata, SSO/OID and
potentially
> Portal (amongst others). Those can not be moved to another machine, or
> even to another instance. The related tablespaces can be transplanted,
> but it's far easier to simply leave them alone (other than the standard
> 'RENAME DATAFILE' stuff).
>
> However 'user' data (such as the HTMLDB, Discoverer, Forms or Reports
data)
> can be freely moved using typical techniques such as export/import
provided
> all service references are identified and appropriately updated. Not
> necessarily an easy task, though, if a DBA hasn't been around to identify
> and document it all along.
>
> Without seeing the actual config, whether there is any farming or
clustering
> happening, or even what companents are instaled/involved, it's quite
> difficult to advise. Also, I'm not sure what the OP is attempting to
> accomplish from a business perspective.
>
> /Hans
Received on Thu Aug 05 2004 - 14:04:39 CDT