Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to drop Users DBF file in oracle 11g?

VijayamuruganJun 15 2011 — edited Jun 16 2011

Hi All

I dropped the user and want to free the table space(To import another user(Which has more than 10 GB of record).

the below is my query which i used to import the data and schema

impdp system/test DIRECTORY=dump_dir DUMPFILE=exp_test.dmp FULL=Y LOGFILE=import_test.log REMAP_TABLESPACE=TEST_DATA:USERS

After dropping my user i checked into the folder C:\oradata\orcl and i found two files USERS01.DBF(21.1GB,its 21.1 gb because i tried to cretae an another schema nd i got stuc up with low disk space.) and TEMP01.DBF(1.66GB).

I tried to drop USERS tablespace and i could nt able to do it.

Can any one help me to reduce the size of both two files?

Thanks & Regards
Vijay

Edited by: Vijayamurugan on Jun 15, 2011 8:22 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 14 2011

Added on Jun 15 2011

#general-database-discussions

9 comments

3,353 views