In article <70nko2$9pr$1_at_news.netvision.net.il>, mousalli_at_applicom.co.il
says...
>
>By mistake I create a new table under USERS and deleted it.
>The problem is that when I try to startup my db I get an error that the file
>doesn't exists. This file was new and empty.
>Can I remove this configuration and startup my db?
SQLDBA> startup mount
SQLDBA> alter tablespace USERS offline immediate;
SQLDBA> alter database open;
SQLDBA> drop tablespace USERS;
This assumes that the tablespace you deleted is USERS, of course :-)
Received on Fri Oct 23 1998 - 13:21:04 CDT
