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

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.

-----Original Message-----
From: Hemal Pandya [mailto:h00_at_hotmail.com] Posted At: Friday, April 04, 2003 8:22 AM Posted To: server
Conversation: error creating database from template ( NT/9.0.1 to linux/9.2.0.1.0)
Subject: Re: error creating database from template ( NT/9.0.1 to linux/9.2.0.1 .0)

Ok, so I cannot use the template to transfer the database from NT to Linux.

Creating scripts while creating database is not an option; I work in Development environment and the database schema changes all the time. This
changes are reflected directly to the database.

So my next questions is, can I generate these scripts from the database? I
guess I would need the script(s) to contain commands to create the database,
tablespaces and users.

Can I then execute this script on Linux and then import the complete dump
file from NT to create the database on Linux?

Thanks again.

On Thu, 03 Apr 2003 09:25:31 +0100, Norman Dunbar wrote:

> Morning Hemal,
>

[....] Received on Fri Apr 04 2003 - 03:53:23 CST