Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Attach a tablespace to diff instance?

Attach a tablespace to diff instance?

From: Bellatlantic <noone_at_nowhere.com>
Date: Wed, 12 May 2004 22:17:28 GMT
Message-ID: <Ynxoc.28654$vz5.16552@nwrdny01.gnilink.net> 





Howdy,



Running Oracle 9.2.0.3 on HP ux 11i



We have a production environment that someone truncated a partition on.



Is there any way to get a backup of the data file (single file) then attach
the tablespace/file to our development instance?  We are then planning to
export from there and re-import to production.



Thanks, I am just getting to know some of the fancy features of 9i.



Wayne B.
Received on Wed May 12 2004 - 17:17:28 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US