Elton's Blog

sqlplus system/password@orcl

SQL> @/path/to/file/sample.sql

sqlldr userid=username/password control=sample.ctl

select * from tab;
select table_name from user_tables;

select table_name from all_tables;

sqlplus system/password@orcl

select file_name from dba_data_files;
 
FILE_NAME
--------------------------------------------------------------------------------
/Users/oracle/oradata/orcl/users01.dbf
/Users/oracle/oradata/orcl/sysaux01.dbf
/Users/oracle/oradata/orcl/undotbs01.dbf
/Users/oracle/oradata/orcl/system01.dbf
/Users/oracle/oradata/orcl/example01.dbf

create temporary tablespace decernis_temp
tempfile '/Users/oracle/oradata/orcl/decernis_temp01.dbf'
size 32m
autoextend on 
next 32m maxsize 2048m
extent management local;
 
Tablespace created.

create tablespace decernis_data
logging
datafile '/Users/oracle/oradata/orcl/decernis_data01.dbf'
size 32m 
autoextend on
next 32m maxsize 2048m
extent management local; 
 
Tablespace created.

create user decernis identified by password
default tablespace decernis_data
temporary tablespace decernis_temp;

grant dba,connect,resource to decernis;