Path: news.easynews.com!easynews!feedwest.news.agis.net!aleron.net!sfo2-feed1.news.algx.net!allegiance!news-out.spamkiller.net!propagator-la!news-in-la.newsfeeds.com!news-in.superfeed.net!enews.sgi.com!sdd.hp.com!news-west.eli.net!not-for-mail Message-ID: <3CACC182.BC16EA61@exesolutions.com> From: damorgan X-Mailer: Mozilla 4.79 [en] (Win95; U) X-Accept-Language: en MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server Subject: Re: URGENT: Need to move TS from ufs to vxfs file system References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 40 Date: Thu, 04 Apr 2002 21:11:30 GMT NNTP-Posting-Host: 156.74.250.7 X-Complaints-To: yvonne.tracy@ci.seattle.wa.us X-Trace: news-west.eli.net 1017954690 156.74.250.7 (Thu, 04 Apr 2002 14:11:30 MST) NNTP-Posting-Date: Thu, 04 Apr 2002 14:11:30 MST Organization: City of Seattle NewsReader Service Xref: easynews comp.databases.oracle.server:142092 X-Received-Date: Thu, 04 Apr 2002 14:09:15 MST (news.easynews.com) According to the DBA handbook the steps are: 1. Do not shut down the database 2. Take the tablespace off-line 3. Move the datafile(s) 4. Use the ALTER TABLESPACE command to rename the file within the database 5. Bring the tablespace back on-line. This does not correspond with what you did. Reference: Oracle 8i DBA Handbook, Loney & Theriault, pg 138. Daniel Morgan Larry wrote: > I really need help! FAST! > > I have some large tablespaces I need to move from a ufs file system to > a new-and-improved veritas file system. We are out of space and I > have to get this done. I followed the instructions to do this task... > > shutdown > copy dbf files to new location (I didn't move the files...) > startup mount > alter files '/v01/...' to '/v05/..' > alter database open > > Problem is, when I run a query against a table that is in the > relocated TS, the query just hangs. If I shutdown and put everything > back the > way it was, the query works fine. > > I am running Oracle 8.1.7. > > Any thoughts?