Xref: alice comp.databases.oracle:76948 comp.databases.oracle.server:79484 Path: alice!news-feed.fnsi.net!feed.newsfeeds.com!newsfeeds.com!cyclone.pbi.net!131.119.28.147!su-news-hub1.bbnplanet.com!paloalto-snf1.gtei.net!news.gtei.net!newsfeed.stanford.edu!remarQ70!remarQ.com!supernews.com!remarQ69!WReNclone!WReNphoon4.POSTED!WReN!not-for-mail From: Yong Subject: Re: Move whole database Newsgroups: comp.databases.oracle.server,comp.database.oracle.server,comp.databases.oracle,comp.database.oracle Message-ID: <1e43bb60.96bc78f3@usw-ex0110-076.remarq.com> Lines: 14 Bytes: 585 X-Originating-Host: 209.245.204.235 Organization: http://www.remarq.com: The World's Usenet/Discussions Start Here References: <83ogs1$4gt$1@nnrp1.deja.com> X-Wren-Trace: eHlcdHVsK2EqIGJ/e2oqIUtzaHRzcndsc3g2KCA0LmsiKncqJ20iJSYt Date: Sat, 01 Jan 2000 08:47:31 -0800 X-Complaints-To: wrenabuse@remarq.com X-Trace: WReNphoon4 946745207 10.0.2.76 (Sat, 01 Jan 2000 08:46:47 PST) NNTP-Posting-Date: Sat, 01 Jan 2000 08:46:47 PST Another way to do this is create the new database, export the old database and import into your new database. It's tedious and timeconsuming. But this is a good opportunity to do some cleanup so your disk space is better used. You can even change some parameters you can't change in other ways, db_block size, character set etc. ---Yong Huang----

Email:yong321@yahoo.com Web: http://www.stormloader.com/yonghuang/ * Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful