dealing with offline datafile
796727Feb 14 2011 — edited Feb 15 2011I have a tablespace with one empty offline datafile among other datafiles. I can't easily put it online and delete it because there are no archivelogs available (21 days window). There is only one schema that uses this tablespace. i can expdp this schema with no problem. I plan to export this schema and import it into a new tablespace. Then I can drop the tablespace with that offline datafile. Are there any precautions I should be aware of before I start with my procedure?
regards