Oracle Database Discussions

Dear,

I am planing re-ogranization dbfs datafile was 99% usage by DBMS_DBFS_SFS.REORGANIZEFS.

My databases is 11g (11.2.0.4) and 12c (12.2.0.1). And I wish reuse dbfs_ts tablespace original

First-step, I created file system by dbfs_create_filesystem step, it done.

• dbfs_user@>@?/rdbms/admin/dbfs_create_filesystem DBFS_TS FS_TEMP

• dbfs_user@> select s_owner,s_name,p_name from dbfs$_Stores;

  S_OWNER S_NAME P_NAME
  -------------------------------- -------------------------------- --------------------------------
  DBFS_USER FS_FS sample1
  DBFS_USER FS_FS_TMP sample1

2nd step, grant privileges to dbfs_user (in my case, this is dbfs_admin)

• . sys@> grant ALTER ANY TABLE to dbfs\_user;  
  

  . sys@> grant DROP ANY TABLE to dbfs_user;
  . sys@> grant LOCK ANY TABLE to dbfs_user;
  . sys@> grant CREATE ANY TABLE to dbfs_user;
  . sys@> grant SELECT ANY TABLE to dbfs_user;
  . sys@> grant CREATE ANY TRIGGER to dbfs_user;
  . sys@> grant CREATE ANY INDEX to dbfs_user;
  . sys@> grant CREATE TABLE to dbfs_user;
  . sys@> grant CREATE MATERIALIZED VIEW to dbfs_user;
  . sys@> grant CREATE TRIGGER to dbfs_user;

3rd step, reorganize

• dbfs_user@> EXEC DBMS_DBFS_SFS.REORGANIZEFS('FS_FS', 'FS_FS_TMP');

4th, drop file_system temp, and then, I've got this error

• dbfs_user@> @?/rdbms/admin/dbfs_drop_filesystem FS_TEMP

  Warning: Function created with compilation errors.

  Errors for FUNCTION FSENQNAME:

  LINE/COL ERROR
  -------- -----------------------------------------------------------------
  11/1 PLS-00103: Encountered the symbol "CREATE"
  fsDrop('FS_TEMP', true);
  *
  ERROR at line 2:
  ORA-06550: line 2, column 3:
  PLS-00201: identifier 'FSDROP' must be declared
  ORA-06550: line 2, column 3:
  PL/SQL: Statement ignored

  Errors for FUNCTION FSENQNAME:

  LINE/COL ERROR
  -------- -----------------------------------------------------------------
  11/1 PLS-00103: Encountered the symbol "CREATE"
  drop procedure fsDrop
  *
  ERROR at line 1:
  ORA-04043: object FSDROP does not exist

  My questions:

  - Why dbfs_drop_file_system did not drop? Was I wrong?

  - I did in another 19c database, and all steps in this procedure was done successful, but only failed in 11g and 12c.

  Please guide me to do. Thank you very much