>> 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