Hallo Team,
I messed up. I created and added files to a wrong table space (user_data) instead PERFSTAT and i would like to claim it back if possible.
This is the command that i ran and it ran successfully but it was not supposed to be user_data :
ALTER TABLESPACE USER_DATA ADD DATAFILE '/u05/oracle/oradata/bill/dbf/data1/PERFSTAT_BILL_08.DBF' SIZE 5G;
ALTER TABLESPACE USER_DATA ADD DATAFILE '/u05/oracle/oradata/bill/dbf/data1/PERFSTAT_BILL_09.DBF' SIZE 5G;
ALTER TABLESPACE USER_DATA ADD DATAFILE '/u05/oracle/oradata/bill/dbf/data1/PERFSTAT_BILL_10.DBF' SIZE 5G;
ALTER TABLESPACE USER_DATA ADD DATAFILE '/u05/oracle/oradata/bill/dbf/data1/PERFSTAT_BILL_11.DBF' SIZE 5G;
ALTER TABLESPACE USER_DATA ADD DATAFILE '/u05/oracle/oradata/bill/dbf/data1/PERFSTAT_BILL_12.DBF' SIZE 5G;
ALTER TABLESPACE USER_DATA ADD DATAFILE '/u05/oracle/oradata/bill/dbf/data1/PERFSTAT_BILL_13.DBF' SIZE 5G;
ALTER TABLESPACE USER_DATA ADD DATAFILE '/u05/oracle/oradata/bill/dbf/data2/PERFSTAT_BILL_14.DBF' SIZE 5G;
i would like to reverse and claim back the space then run like below:
ALTER TABLESPACE PERFSTAT ADD DATAFILE '/u05/oracle/oradata/bill/dbf/data1/PERFSTAT_BILL_08.DBF' SIZE 5G;
ALTER TABLESPACE PERFSTAT ADD DATAFILE '/u05/oracle/oradata/bill/dbf/data1/PERFSTAT_BILL_09.DBF' SIZE 5G;
ALTER TABLESPACE PERFSTAT ADD DATAFILE '/u05/oracle/oradata/bill/dbf/data1/PERFSTAT_BILL_10.DBF' SIZE 5G;
ALTER TABLESPACE PERFSTAT ADD DATAFILE '/u05/oracle/oradata/bill/dbf/data1/PERFSTAT_BILL_11.DBF' SIZE 5G;
ALTER TABLESPACE PERFSTAT ADD DATAFILE '/u05/oracle/oradata/bill/dbf/data1/PERFSTAT_BILL_12.DBF' SIZE 5G;
ALTER TABLESPACE PERFSTAT ADD DATAFILE '/u05/oracle/oradata/bill/dbf/data1/PERFSTAT_BILL_13.DBF' SIZE 5G;
ALTER TABLESPACE PERFSTAT ADD DATAFILE '/u05/oracle/oradata/bill/dbf/data2/PERFSTAT_BILL_14.DBF' SIZE 5G;