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

Home -> Community -> Usenet -> c.d.o.server -> Re: copying orace schema

Re: copying orace schema

From: tojo <Tojo_at_hotmail.com>
Date: Mon, 18 Nov 2002 12:38:35 +0100
Message-ID: <MPG.1842efa6df70719e9896d0@news.t-online.de>


In article <1037610133.360794_at_sj-nntpcache-3>, prkothan_at_hotmail.com says...
> Hi all,
> I need to copy the schema of my project.
> I require all the tables with data to be copied into new tablespace &
> username.
> Can anyone suggest me a easy way to do it.
>

1. export the database using the "owner" parameter. 2. import the database using the "fromuser" and "touser" parameters.

Received on Mon Nov 18 2002 - 05:38:35 CST

Original text of this message

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