Oracle Database Discussions

Hi All,

I had a schema called dmuser1 which i had allocated to 'odmperm' tablespace,
now i was running short of space in the drive where oracle is installed and
there was a datafile of' odmperm' tablespace ,
so i thought of dropping the 'odmperm' tablespace and corresponding datafile ,
so i altered the dmuser1 schema to point to USERS tablespace by running below code

ALTER USER dmuser1 default tablespace USERS quota unlimited on USERS.

then i ran
select * from dba_users;

here user dmuser1 had changed to USERS tablespace, so i used the below command to delete the datafile

DROP TABLESPACE ODMPERM INCLUDING CONTENTS;

now when i log into dmuser1 schema, none of my tables are present and i dont have the backup also, so please help me in resolving this.


please.

Thanks in advance.