Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> DBA Help
Hello,
Was wondering knew what to do if they accidentally deleted the dbf file in a unix system without having dropped the tablespace yet? There is no data lost, but just to clean out the system so the oracle tables no longer have a recollection of that tablespace. I goofed and deleted the file first before dropping the tablespace. I understand it should be the other way around. Thanks for any input.
Kevin Chin
Kevin A. Chin E-Mail: kevin.chin_at_lmco.com Lockheed Martin Corporation Voice: (703) 293-4134 Integrated Solutions Center (ISC) FAX: (703) 293-41103201 Jermantown Road
![]() |
![]() |