Re: copying orace schema

From: Alistair Thomson <thomson_alistair_at_no.spam.yahoo.co.uk>
Date: Mon, 18 Nov 2002 13:46:00 -0000
Message-ID: <araqup$847$1$8300dec7@news.demon.co.uk>

Create a new schema with a default tablespace of the new tablespace where you waqnt the objects to go.

Export your schema.

Import using the fromuser touser flags eg

imp file=myfile.dmp fromuser=firstschemaname touser=newschemaname log=myfile.log buffer=2000000

Hope it helps.

Alistair

"prasanna" <prkothan_at_hotmail.com> wrote in message news:1037610133.360794_at_sj-nntpcache-3...
> 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.
>
> Thanks,
> Prasanna
>
>
>
Received on Mon Nov 18 2002 - 07:46:00 CST