HElp please.!!

I had some problems importing a file which was too large. so i created a new datafile for the tablespace and set it to AUTOEXTEND ON. but it was too large for some strange reason(even though the import was quite small) and took up all the space on the device.

 so, I took the tablespace
offline and then stupidly deleted it.

I am in NOARCHIVELOG mode so cannot recover , but would just like to get rid of the datafile from that tablespace and just start over.

any advice,
thanks
Paul

• Posted from RemarQ - http://www.remarq.com - Discussions Start Here (tm) ****