5 Replies Latest reply: May 12, 2011 6:54 AM by Hemant K Chitale RSS

    how to drop datafiles in oracle 10g r2

    606331
      Hi all,

      Db :oracle 10.2.0.3
      os:solaris 10

      tablespace name: jllp_tabs01
      datafile:
      /ora/data001/jllp/jllp_tbs01_tbl_1.dbf
      /ora/data001/jllp/jllp_tbs01_tbl_2.dbf
      /ora/data001/jllp/jllp_tbs01_tbl_3.dbf
      /ora/data001/jllp/jllp_tbs01_tbl_4.dbf

      its has consisting of 4 datafiles, I need to drop the 2 of them perminently.
      the datafile are having data.


      how to drop the datafiles.
      please suggest me.