We need to move datafile from one location to another location using a procedure.

CREATE OR REPLACE PROCEDURE FILE_MOVING_FROM_DISK AS
DISK_FILE_NAME VARCHAR2(200);
RES_TS VARCHAR2(100):='USERS';
sql_stmt VARCHAR2(500);
DISK_PATH VARCHAR2(200):='/u02/app/oracle/oradata/';
FILE_NAME VARCHAR2(50):='users1a.dbf';
BEGIN


sql_stmt:='alter database move datafile '||''''||DISK_FILE_NAME||''''||' to '||''''||DISK_PATH||FILE_NAME||''''||';';

EXECUTE IMMEDIATE sql_stmt;

END FILE_MOVING_FROM_DISK;

When I am executing this procedure getting an error as shown below.

ERROR at line 1:
ORA-02231: missing or invalid option to ALTER DATABASE
ORA-06512: at "USER1.FILE_MOVING_FROM_DISK", line 14
ORA-06512: at line 1

Please let me know user1 require any additional privileges to execute it.

SQL> alter database move datafile 'X:\ORADATA\DB18\PDB1\DEMO.DBF' to 'C:\TEMP\DEMO.DBF';

execute immediate q'{alter database move datafile 'X:\ORADATA\DB18\PDB1\DEMO.DBF' to 'C:\TEMP\DEMO.DBF'}';