Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How do you make a copy of a tablespace?
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
![]() |
![]() |