Re: error creating database from template ( NT/9.0.1 to linux/9.2.0.1 .0)

Thanks a lot for your help Norman, I think I am set for now.

I do have access to dba stuff at work; I have toad and I have the password so I should be able to create the scripts. I don't think I want to go the select * from user* route; not until I have been playing DBA on my home machine for a while at least :)

Meanwhile, I also found out that I don't really need to create the tablespaces or the users to be able to restore from the dump file, all I need is a database, which I can create using dbca and then an export file created with FULL=Y when imported creates the users as well.

Right now I do think this excercise should be easier then this. Maybe it is easy but I find it difficult because I dont do it often...

Again, thanks for your help.

On Fri, 04 Apr 2003 10:53:23 +0100, Norman Dunbar wrote:

> Morning Hemal,
>
> you *can* create scripts from the database - using something like TOAD.
> But if you have no access (at work) to the dba_stuff then you are not
> going to be able to recreate the database.
>
> You could use dbca to create a general database and add your own stuff
> as follows :
>
> select * from user_tablespaces
> should tell you initial, next, extent management & uniform sizes etc,
> but it won't tell you how big they are.
>
> select * from user_ts_quotas
> will tell you how much quota you are allocated on each of your user's
> tablespaces - again, you won't get the full sizes but you have a decent
> guess at it !
>
> The info above means you can now create as many new tablespaces as you
> have at work (the above was run on your work database !) on your home
> database. You can then create the users.
>
> You then need to get an import file from work, and import that into your
> home database.
>
> It's not perfect, but it's a start !
>
>
> HTH
>
> Cheers,
> Norman.
>

[....] Received on Fri Apr 04 2003 - 07:14:49 CST