Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Drop datafile/tablespace from svrmgrl

Drop datafile/tablespace from svrmgrl

From: Tim Smith <timasmith_at_hotmail.com>
Date: 18 Oct 2002 09:58:51 -0700
Message-ID: <a7234bb1.0210180858.2505ba5e@posting.google.com>


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 - 11:58:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US