Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> error creating database from template ( NT/9.0.1 to linux/9.2.0.1 .0)
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.
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: 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> Received on Fri Apr 04 2003 - 08:55:10 CST