> >> Is there a an easy way to reproduce all the tables/domains
> >> that i have created in a database using the SYSDBA username
> >> in a databsae created by my new username?
> ...
> > You extract the metadata of the database. this results in a
> > script. you can ensure that the create line is edited to a
> > new database name and path. Ensure that the user is changed
> > as required and is a valid user on the erver in question. And
> > then you run the script., if you need to then you pump the
> > data across.
>
> This process is completely automated using the Rebuild option
> of DBak: http://www.telesiscomputing.com.au/dbk.htm
>
> I have always considered database object ownership is one of
> the shortcomings of DBak versus gbak. With DBak the DDL is
> executed using whatever user you specified in the settings,
> making that user the new owner and effectively losing all
> ownership details from the original database. But in this
> instance it can be considered a "feature". :-)
>
> --
> Geoff Worboys
> Telesis Computing

it certainly, since you can always specify the original owner anyway and
have no change
Alan