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 -> Re: How do you make a copy of a tablespace?

Re: How do you make a copy of a tablespace?

From: Mike Lacey <lacey_michael_j/swby_at_swby.cgo.Cargill.Com>
Date: Thu, 25 Jun 1998 13:22:15 +0100
Message-ID: <6mtfdr$rj2@wind.cargill.com>


Have you considered exporting the data you want - or the whole database - using the exp command? This could then be read into another database or into another schema on the same database.

Mike

> My goal is to make a "demo" for potential customers to use, but I don;t
want them using the actual databse that holds important information - so I want to create a similar tablespace that they will access and "play" with without hurting the real live d-base.
>
> How would I copy the exact structure (and we'll say data too) to another
tablespace... as well as User privledges, etc.
>
>Much Appreciated,
>Sean
Received on Thu Jun 25 1998 - 07:22:15 CDT

Original text of this message

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