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

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Thu, 3 Apr 2003 09:25:31 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA70381D534@lnewton.leeds.lfs.co.uk>

Morning Hemal,

I was under the opinion that all the templates stored was a description of the files, sizes, locations etc - not the actual files themselves. However, I've just had a look at a template I created and I find that there is a small XML file called template_name.dbc and a very large template_name.djf so I suspect you are correct - the djf file does indeed contain the blank datafiles.

As this is the case, the NT format files are no use on a Linux box. Oracle will not let you transfer what are effectively binary files between operating systems and even sometimes between the same OS just on different server types - as I know from past experience.

If you really need your work template at home, then you'll need to get your DBA to crerate you a set of scripts (not a template) from the work template and running those at home. He/she/it can do this as the final stage of dbca instead of creating a new database. When you have altered the forward/backward slashes and file locations in these scripts - and possibly removed some directory creates etc, you can run them to create a database and then import your work data in the normal manner.

HTH Regards,
Norman.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------

-----Original Message-----
From: Hemal Pandya [mailto:h00_at_hotmail.com] Posted At: Thursday, April 03, 2003 12:13 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)

Norman Dunbar wrote:
> Morning,
>
> it sounds like you are actually trying to clone a database not create
> one from a template- but I could be wrong !

Thanks for your response, Norman.

You can say that I am trying to clone a database, in the sense that I am

trying to transfer the database from work to home. The template was created at work by the DBA from the existing database and I am trying to

create a database from that template.
<SNIP> Received on Thu Apr 03 2003 - 02:25:31 CST