Re: copy schema

From: Kevin <kevin123_at_m1.is.net.tw>
Date: 2000/06/21
Message-ID: <8iq7s8$5ea_at_netnews.hinet.net>#1/1

I have example :
su - oracle
cat .profile
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 ( depends on ur character set ) or NLS_LANG=TRADITIONAL CHINESE_TAIWAN.ZHT16BIG5 export NLS_LANG

re login oracle

exp system/manager file=expdat.dmp owner=aaaa full=y inctype=complete imp system/manager file=expdat.dmp fromuser=aaaa touser=bbbb Kevin

---

"Jerry Gitomer" <jgitomer_at_erols.com> ????? news:20000522.3490600_at_noname.nodomain.nowhere...

Easiest way is using export and import. When you import use the fromuser touser options. You may also want to use the option that generates DDL (I think it is indexfile) that you can edit in order to control the placement of tables and indexes in your tablespaces.

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 5/15/00, 3:34:00 PM, Steve Maxey <sdm_at_profitool.com> wrote regarding copy schema:

> Is there a way to copy a users schema to another user, or a least
> generate a current users schema with the create table, create index,
> etc. statements?
Received on Wed Jun 21 2000 - 00:00:00 CEST