Re: Moving 9i DB from PC-A to PC-B in Win 2k

Hi oscar_1, thanks for writing this:
>
> Thanks Anna.
>
> I am a little rusty and would like to pick your brain a bit more, if
> you're willing?
>
> The import is actually on a Windows Server 2000 box. I'm not that
> familiar with process (creating empty dbs, that is), other than I know
> I need to use oradim initially to set the stage for using svrmgr to
> create the dbs. Questions: What is the password used for in parameter
> INTPWRD in oradim and enlight of the fact that you have to have sysdba
> privs to do a full import, are default sysdba's created upon creation
> of empty dbs?
>
> Appreciate your help.
>
> --
> Posted via http://dbforums.com
>

It can get pretty confusing, can't it? I'm with you. But maybe this will help.

You use oradim to administer the Windows service for Oracle (or you can simply get to it thru your control panel - as I prefer - as a member of the Admistrator group).

You probably then want to create an "empty" database with the Database Config Assistant (DBCA) off your start menu (and copy the "starter" db from the CD when DBCA asks - so you don't have to wait for Oracle to compile and resolve those 8000+ java classes). You will get the standard userids - sys, system, etc. BTW, you should not get in the habit of using svrmgr since it disappears with 9i.

Then create your tablespaces (manually or with OEM). Then create the appropriate schema user accounts.

Then import into them with something like:

  imp system/manager ... fromuser=<src_userid> touser=<dst_userid>

Then immediately change the password for the SYS and SYSTEM userids (you are "forced" to do this for 9i).

-- 
[:%s/Karsten Farrell/Oracle DBA/g]