Re: copying database structure to new database with different tablespace names

michael cooke wrote:

> Oracle 8.1.7
> windows 2000 server
> I need to create a second database with the same structure as the current
> one (no users roles or grants). new instance, new database name and
> different tablespace names. Is ther a logical. practical way to do this?
>
> thanks
> Mick

Depends on what you mean by your use of the word 'database'. If you really mean schema ... export / import. If you mean another database ... transportable tablespaces, export / import, database_link, advanced replication.

You've provided far too little information from which to formulate much of a response.

Unless the point of this request is fail-over I'd review Cobb's rules of normalization.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)