Re: How to move Tablespace / Database ??
From: bgbgbg <brian.gallagher_at_iona.com>
Date: Tue, 19 Dec 2000 16:52:01 -0000
Message-ID: <91o47h$m50$1_at_bvweb.iona.com>
Date: Tue, 19 Dec 2000 16:52:01 -0000
Message-ID: <91o47h$m50$1_at_bvweb.iona.com>
- you can backup controlfile to trace
- shutdown db
- use o/s commands to move data files to new location
- edit tracefile and change as appropriate
- connect internal
- startup nomount
- run tracefile# -alter db open
rgds
brian
Received on Tue Dec 19 2000 - 17:52:01 CET