SQL command for T24 area creation in the DB part

SQL> select file_name,tablespace_name,bytes/1024/1024/1024 "Size" from dba_data_files where tablespace_name IN ('T24ITDATA','T24ITINDEX');

FILE_NAME                           TABLESPACE_NAME             Size(GB)
----------------------------------- ------------------------------ ----------
/test01/t24it/t24itdata01.dbf       T24ITDATA                              10
/test01/t24it/t24itindex01.dbf      T24ITINDEX                              3

SQL> drop tablespace t24itdata including contents and datafiles cascade constraints;


SQL> drop tablespace t24itindex including contents and datafiles cascade constraints;



select file_name,tablespace_name,bytes/1024/1024/1024 "Size" from dba_data_files where tablespace_name IN ('T24ITDATA','T24ITINDEX');


create tablespace t24itdata
datafile '/test01/t24it/t24itdata01.dbf' size 10g


create tablespace t24itindex
datafile '/test01/t24it/t24itindex01.dbf' size 3g


create user t24it identified by t24it
default tablespace t24itdata
temporary tablespace temp;


impdp t24it/t24it directory=EXPDP_DIRECTORY dumpfile=xxxxxxx.dmp logfile=xxxxxxxxx.ilog remap_schema=t24master:t24it remap_tablespace=t24masterdata:t24itdata t24masterindex:t24itindex