Re: how to create database objects...

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Wed, 27 Jan 1999 13:43:46 GMT
Message-ID: <36af17de.1332445@192.86.155.100>

A copy of this was sent to virgil <horst.k_at_netway.at> (if that email address didn't require changing) On Wed, 27 Jan 1999 11:38:50 +0100, you wrote:

>along with oracle 8.0.5 come tons of scripts. i am searching for a
>script which creates all system tables, views, ... in an empty database.
>i have only created the database and the tablespaces.
>
>oracle 8.0.5 (unix)
>
>thanks,
>horst

exp with rows=y on the source database. imp full=y on the target database.

exp will get the tables, constraints, views, grants, users, etc,etc from the source database (minus the data).

imp will recreate it for you.  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Wed Jan 27 1999 - 07:43:46 CST