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 -> copying database structure to new database with different tablespace names

copying database structure to new database with different tablespace names

From: michael cooke <michael.cooke_at_tiscali.co.uk>
Date: Wed, 30 Jul 2003 20:02:25 +0100
Message-ID: <3f28159b$1_1@mk-nntp-2.news.uk.tiscali.com>


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 Received on Wed Jul 30 2003 - 14:02:25 CDT

Original text of this message

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