Re: Replicating a user across DBs

Hi Jesse

> In 8.1.7, is there a way to easily replicate a user from one DB (e.g.
> "development") to another (e.g. "production")? I can export all the
objects
> in the schema, but export/import won't recreate the schema in the import
DB.
>
> I've been using OEM to create a script (reverse engineered from "Create
> like..."), but the resulting script requires editing and the assignment of
a
> resource plan doesn't always play nice, either.
>
> There has got to be a better way...

The freeware DBATool will do this. It reads an export file created ROWS=N and will generate the schema DDL from it (including grants TO and FROM, public synonyms dblinks, profiles, etc etc). The DBATool can also adjust or remove the tablespace and storage clauses on the output scripts and has nifty DDL to HTML converter.

DBATool: http://www.DataBee.com

Regards
Dale Edgar
Net 2000 Ltd.
Dale_at_DataBee.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Dale_at_DataBee.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).