Re: Fixing a DB

Ken,
I don't think you will need steps 2 thru 5. After step 1, just write sql that will spool out "alter index <blah> rebuild tablespace <new_tablspace>" & run the resulting sql.
Will that work ?
HTH
Srini Chavali
Oracle DBA
Cummins Inc

Ken Janusz <ken.janusz_at_sufsys.com>@fatcity.com on 11/21/2001 08:25:34 AM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:

We have a DB that is currently in more-or-less development mode for a state government client. The DB has been created (11,300 lines of SQL*Plus code) with the tables and indexes stored in the permanent tablespace
(SOS2_TBLSPC). There is no separate tablespace for indexes. The DB
currently holds test data. I think the process to correct this would be:

1. Determine the size, etc. of the INDEX tablespace, write the script and then run it to create the tablespace.
2. Go through the DDL SQL script for OKSOS (state gov. office name abbreviation) and change the tablespace name SOS2_TBLSPC to the new INDEX tablespace name.
3. Then run the DDL SQL script to create the new DB.
4. Then do and Export of the data from the old DB and Import it into the new DB.
5. Then I think I have to regenerate your indexes. I'm not clear on this point. Will the Export/Import process may take care of this?

Is there anything I have missed? I'm sure there is.

Thanks,

Ken Janusz, CPIM
Database Conversion Lead
Sufficient System, Inc.
Minneapolis, MN

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
  INET: ken.janusz_at_sufsys.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Srini.Chavali_at_Cummins.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).