Re: upgrading oracle
Date: Tue, 8 Dec 1992 17:38:29 GMT
Message-ID: <kpalm.723836309_at_doc>
bellan_at_cs.umb.edu (Bechara Bellan) writes:
>Hi,
>I am in the process of upgrading oracle to the latest version on a
>UNIX server. I have a question about importing the full database into
>the new version. I have a complete backup in case something tragic
>happens, but my question is.
>I have two table spaces configured for the same database, how can I
>merge both of them under one tablespace?
>I have no problem upgrading and keep the same format.
>Thankk you in advance and I appreciate any help.
>B. Bellan
This is a bit tricky, but it can be done. Let's say that the tablespace you want to drop is called JUNKIT. BEFORE you export your entire database (I know, you already did your export), revoke resource from all database users on JUNKIT. Then, alter all users so that their default and temporary tablespaces are not JUNKIT, but instead are the ones you really want it to be. Grant resource on these tablespaces to the users. Basically, you want to configure your database the way you want it to be, but don't move your database objects --- export/import will do that.
Then, you should use a script to create your new database, and in this script make a 50kb tablespace called JUNKIT that you will later drop. This will prevent the import from trying to create your old JUNKIT file, which I presume was much larger and possibly pointing to a device/file that you don't want to have written over.
Once your database is created, import your entire database. If you did all the prerequisite steps correctly, you should not have any objects in JUNKIT --- use SELECT COUNT(*) FROM SYS.DBA_SEGMENTS WHERE TABLESPACE_NAME ='JUNKIT'. If it comes up 0, you're okay; otherwise, you have more research to do. Once 0, you can drop the tablespace (don't take the tablespace offline first, otherwise you'll end up will a DEFERRED_ROLLBACK segment in your SYSTEM tablespace (which doesn't hurt anything, but you can't get rid of it until you recreate your database).
This should help.
Kent Received on Tue Dec 08 1992 - 18:38:29 CET