Re: Drop datafile/tablespace from svrmgrl

From: <kenneth.koenraadt_at_no-spam.hotmail.com>
Date: Fri, 18 Oct 2002 20:21:42 GMT
Message-ID: <3db06b13.508691@news.mobilixnet.dk>

Hi Tim;

Assuming you are running 8i or higher :

SVRMGR>alter database datafile '/dev/rmyfile_5664_1' offline drop;
SVRMGR>alter database open; -- database can now be opened
SVRMGR>drop tablespace <tablespace with datafile /dev/rmyfile_5664_1>

including contents;

• Kenneth Koenraadt

On 18 Oct 2002 09:58:51 -0700, timasmith_at_hotmail.com (Tim Smith) wrote:

>Hi I get
>
>SVRMGR> alter database open;
>alter database open
>*
>ORA-01115: IO error reading block from file 48 (block # 262144)
>ORA-01110: data file 48: '/dev/rmyfile_5664_1'
>ORA-02893: ssaiorwb: lio_listio failed
>IBM AIX RISC System/6000 Error: 22: Invalid argument
>Additional information: 262144
>Additional information: 125330442
>Additional information: 387458855
>
>Can you tell me how to drop this data file and associated tablespace
>while the database is mounted from svrmgrl?
>
>This is not a production database and I not worried about the contents
>- this happened while importing.
>
>thanks!
>
>Tim
Received on Fri Oct 18 2002 - 15:21:42 CDT