RE: Fixing a DB

Why not just create the tablespace and move the indexes? alter index rebuild with new storage parameters.

> -----Original Message-----
> From: Ken Janusz [SMTP:ken.janusz_at_sufsys.com]
> Sent: Wednesday, November 21, 2001 8:26 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Fixing a DB
>
> 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: Koniszewski, Mike
  INET: mkonisze_at_fairpoint.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).