Re: Newbie Install Question

In article <01bb3ad0.10b18aa0$2811fccd_at_iunknown.erols.com>, iunknown_at_erols.com says...
>
>I used oracle installer to set up oracle 7.2.2 and an instance on an HP
>9000 server running HP-UX 9.05.
> I used the default installation, but I'm afraid all my table spaces and
>files are on my root directory. How do I move my files and tablespaces to
>other disks? Do I build the directory structure, set permissions, the edit
>the initdb.ora file to enclude the /disk and parameters then restart
>database? Also, I need to set up a large temp users tablespace to so i
>can do a distinct query on a table with 40,000+ records. I think this is
>related to my tablespace issues. Thanks for any suggestions.
>
>
You can move all the tablespace datafiles by using the rename datafile option: take the tablespace offline, copy the datafiles to the new directory, bring the tablespace back online, use rename datafile command. For the system tablespace however, you will need to shut the database down, after backing up the control file to trace. copy the system datafile to the new location and then edit the backed up controlfile to point to the new location. do a startup nomount and execute the trace file, taking out the reference to the recover. You also will want to copy the old controlfile to save it. Then use the newcontrol file to startup the database. Received on Mon May 06 1996 - 00:00:00 CEST