Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newshosting.com!news-xfer2.atl.newshosting.com!newspeer.monmouth.com!newsfeed.icl.net!newsfeed.fjserv.net!nntp.theplanet.net!inewsm1.nntp.theplanet.net!195.40.4.120.MISMATCH!easynet-quince!easynet.net!newsfeed.kabelfoon.nl!195.129.110.21.MISMATCH!bnewsfeed00.bru.ops.eu.uu.net!bnewsifeed00.bru.ops.eu.uu.net!lnewspost00.lnd.ops.eu.uu.net!emea.uu.net!not-for-mail
Newsgroups: comp.databases.oracle.server
From: Norman Dunbar <Norman.Dunbar@lfs.co.uk>
Subject: error creating database from template ( NT/9.0.1 to linux/9.2.0.1
 .0)
Message-ID: <E2F6A70FE45242488C865C3BC1245DA70383C53E@lnewton.leeds.lfs.co.uk>
Sender: Norman Dunbar <Norman.Dunbar@lfs.co.uk>
Date: Fri, 4 Apr 2003 15:55:10 +0100 
X-Newsreader: Microsoft (R) Exchange Internet News Service Version 5.5.2653.11
References: <16c83c3f.0304012042.56d3cd6d@posting.google.com> <E2F6A70FE45242488C865C3BC1245DA70380B079@lnewton.leeds.lfs.co.uk> <G7Kia.344293$sf5.365223@rwcrnsc52.ops.asp.att.net> <E2F6A70FE45242488C865C3BC1245DA70381D534@lnewton.leeds.lfs.co.uk> <pan.2003.04.04.07.22.19.927980@hotmail.com> <E2F6A70FE45242488C865C3BC1245DA703837B55@lnewton.leeds.lfs.co.uk> <pan.2003.04.04.13.14.45.776008@hotmail.com>
Lines: 67
NNTP-Posting-Host: mailhost3.lfs.co.uk
X-Trace: 1049468975 reading.news.pipex.net 4851 193.129.247.6
X-Complaints-To: abuse@uk.uu.net
Xref: newsfeed1.easynews.com comp.databases.oracle.server:181991
X-Received-Date: Fri, 04 Apr 2003 08:09:30 MST (news.easynews.com)

Afternoon Hemal,

A full export will have every user in it, you might not want that.
It will also have lots of 'create tablespace blah ....' commands in it -
you might not want that either - expecially as the format of the file
names will match those on the NT server while you'll be importing into
Linux which won't have things like 'D:/oradata/....'.

Best advice :

Create your own tablespaces first. 

Create your own user next - and give them quota on each of the
tablespaces they need to have. See the NT database for details of how
much. Always give the a quota of 0 on system - saves problems later on,
esp with imports :o)

Import, from the Full export file but specify 'fromuser=NTUSER
touser=LINUXUSER' on the imp command line. That will put the tables in
the same tablespaces as on NT - assuming you created them with the same
names.

That way, you only import the user(s) you need.


Shouldn't be too hard.


Cheers,
Norman.

-------------------------------------
Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar@LFS.co.uk
Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------





-----Original Message-----
From: Hemal Pandya [mailto:h00@hotmail.com]
Posted At: Friday, April 04, 2003 2:15 PM
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)


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

<SNIP>