RE: database degrade ???

From: Wong, Bing <bing.wong_at_IngramMicro.com>
Date: Thu, 18 Oct 2001 15:40:15 -0700
Message-ID: <F001.003AF5CD.20011018154132@fatcity.com>

First of all, it is pain to several versions on the same box.

I think export by schema owner will work. I think this is cleaner way.

Bing

-----Original Message-----
Sent: Thursday, October 18, 2001 4:21 PM To: Multiple recipients of list ORACLE-L

Hi all,

We installed 815, 817 on Sun 5.6. There is an 817 database, and developers requested to build an exactly same database but at 815 level.

I don't think I can copy 817's backup files and create a 815 db, since the backup already has 817 characteristics. Is there a way to do degrade?

If I create an 815 db, and do an export/import, how do I make sure the dmp from 817 only have 815 characteristics. Full db export won't work, is it? And does schema export has nothing to do with Oracle version, if so, I can use schema dmp file.

Thank you!

Leslie

---

Do You Yahoo!?
Make a great connection at Yahoo! Personals. http://personals.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Leslie Lu
  INET: leslie_y_lu_at_yahoo.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: Wong, Bing
  INET: bing.wong_at_IngramMicro.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). Received on Thu Oct 18 2001 - 17:40:15 CDT