> > You should definitely create your database with your own user and
> >not with SYSDBA and try to connect with that user.
>
> Hi
>
> 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?
>
> Thanks
> Pete

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.

Another way is to ask Thomas Steinmaurer (on this list) for his wonderful
Owner migration tool. which opens your database and changes all system
tables to reflect a new owner. BUT follow the backup/restore sequence
instructions very carefully
Alan