select tablespace_name,file_name,bytes/1024/1024 file_size,autoextensible from dba_temp_files
select * from database_properties where property_name=‘DEFAULT_TEMP_TABLESPACE’;
– Query table space file path
select * from dba_data_files;

/alter user train
temporary tablespace temp;/

– Create table space
CREATE TABLESPACE TRAIN_DATA
LOGGING
DATAFILE ‘F:\ORACLE\ORADATA\ORCL\TRAIN_DATA.ORA’ SIZE 500M
REUSE AUTOEXTEND
ON NEXT 1024K MAXSIZE 32767M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ;

– User
CREATE USER TRAIN PROFILE “DEFAULT”
IDENTIFIED BY ffffff DEFAULT TABLESPACE TRAIN_DATA
TEMPORARY TABLESPACE temp
ACCOUNT UNLOCK;
– Givening the role
GRANT “CONNECT” TO TRAIN WITH ADMIN OPTION;
GRANT “DBA” TO TRAIN WITH ADMIN OPTION;
ALTER USER TRAIN DEFAULT ROLE ALL;