select * from dba_tablespaces;
	select * from dba_data_files;	- data files and associated tablespaces

	CREATE TABLESPACE loctbsp DATAFILE '/u02/oracle/data/loctbsp01.dbf' SIZE 50M
	EXTENT MANAGEMENT LOCAL AUTOALLOCATE;

	SELECT name, value FROM v$sysstat WHERE name = 'redo wastage';

	- add a redo log file group with a block size of 512B
	ALTER DATABASE ora1 ADD LOGFILE GROUP 4 ('/u01/logs/orcl/redo04a.log','/u01/logs/orcl/redo04b.log')
		SIZE 100M BLOCKSIZE 512 REUSE;

	UNDO_TABLESPACE = undotbs_01

	CREATE DATABASE newdb
	USER SYS IDENTIFIED BY sys_password
	USER SYSTEM IDENTIFIED BY system_password
	LOGFILE GROUP 1 ('/u01/app/oracle/oradata/newdb/redo01.log') SIZE 100M,
		   GROUP 2 ('/u01/app/oracle/oradata/newdb/redo02.log') SIZE 100M,
		   GROUP 3 ('/u01/app/oracle/oradata/newdb/redo03.log') SIZE 100M
	MAXLOGFILES 5
	MAXLOGMEMBERS 5
	MAXLOGHISTORY 1
	MAXDATAFILES 100
	CHARACTER SET US7ASCII
	NATIONAL CHARACTER SET AL16UTF16
	EXTENT MANAGEMENT LOCAL
	DATAFILE '/u01/app/oracle/oradata/newdb/system01.dbf' SIZE 325M REUSE
	SYSAUX DATAFILE '/u01/app/oracle/oradata/newdb/sysaux01.dbf' SIZE 325M REUSE
	DEFAULT TABLESPACE users
	  DATAFILE '/u01/app/oracle/oradata/newdb/users01.dbf'
	  SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
	DEFAULT TEMPORARY TABLESPACE tempts1
	  TEMPFILE '/u01/app/oracle/oradata/newdb/temp01.dbf'
	  SIZE 20M REUSE
	UNDO TABLESPACE undots
	  DATAFILE '/u01/app/oracle/oradata/newdb/undotbs01.dbf'
	  SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

	select * from dba_objects;	- all schema objects in the database
	select * from all_objects;	- objects accessible to current user
	select * from user_objects;	- objects owned by current user

	ALTER SESSION SET CURRENT_SCHEMA = schema1;

	select * from dba_tables;	- all relational tables in the database
	select * from all_tables;	- tables accessible to the current user
	select * from user_tables;	- tables owned by the current user

	CREATE TABLE emp
	(emp_id number(10) NOT NULL,
	emp_name varchar2(50) NOT NULL,
	dept_id number(10),
	CONSTRAINT pk_emp_empid PRIMARY KEY (emp_id),
	CONSTRAINT fk_emp_deptid FOREIGN KEY (dept_id) REFERENCES dept(id)
	) tablespace tbsp_1 storage (initial 50k);
	
	CREATE TABLE t1 ... ROW STORE COMPRESS BASIC;	- create table with basic table compression
	CREATE TABLE t1 ... ROW STORE COMPRESS ADVANCED;	- with advanced row compression
	
	DESCRIBE t1;	- show table structure
	SELECT dbms_metadata.get_ddl('TABLE','TABLENAME',['SCHEMA']) from dual;	- show create script

	DROP TABLE t1;
	DROP TABLE t1 PURGE;			- release the space immediately
	DROP TABLE t1 CASCADE CONSTRAINTS;	- drop any foreign keys referencing this table

	RENAME t1 TO t2;	- rename table

	ALTER TABLE t1 ADD CONSTRAINT pk_t1_col1 PRIMARY KEY (col1);	- add a primary key
	ALTER TABLE t1 ADD CONSTRAINT uq_t1_col1 UNIQUE (col1);		- add a unique constraint
	ALTER TABLE t1 ADD CONSTRAINT fk_t1_col1 FOREIGN KEY (col1) REFERENCES t2(col2);	- add a foreign key
	
	ALTER TABLE t1 DROP PRIMARY KEY KEEP INDEX;	- drop the primary key, keeping the index
	ALTER TABLE t1 DROP CONSTRAINT fk_t1_col1;	- drop a constraint
	ALTER TABLE t1 DROP UNIQUE(col1);		- drop a unique constraint
	
	ALTER TABLE t1 DISABLE CONSTRAINT uq_t1_col1;	- disable a constraint
	ALTER TABLE t1 ENABLE CONSTRAINT uq_t1_col1;	- enable a disabled constraint

	ALTER TABLE t1 ENABLE NOVALIDATE CONSTRAINT fk_t1_col1;

	ALTER TABLE t1 READ ONLY;
	ALTER TABLE t1 READ WRITE;

	CREATE SCHEMA AUTHORIZATION scott
	CREATE TABLE dept (
		deptno NUMBER(3,0) PRIMARY KEY,
		dname VARCHAR2(15))
	CREATE TABLE emp (
		empno NUMBER(5,0) PRIMARY KEY,
		ename VARCHAR2(15) NOT NULL,
		hiredate DATE DEFAULT (sysdate),
		sal NUMBER(7,2),
		deptno NUMBER(3,0) NOT NULL
		CONSTRAINT fk_emp_dept REFERENCES dept)
	CREATE VIEW sales_staff AS
		SELECT empno, ename, sal, comm FROM emp WHERE deptno = 30
			WITH CHECK OPTION CONSTRAINT sales_staff_cnst
		GRANT SELECT ON sales_staff TO human_resources;

	CREATE GLOBAL TEMPORARY TABLE temptbl1
		(col1 DATE,
		col2 CHAR(20))
	ON COMMIT DELETE ROWS;

	CREATE TABLE sales
	( prod_id       NUMBER(6),
	  cust_id       NUMBER,
	  bill_date     DATE,
	  quantity_sold NUMBER(3),
	  amount_sold   NUMBER(10,2)
	)
	PARTITION BY RANGE (bill_date)
	( PARTITION sales_q1_2006 VALUES LESS THAN (TO_DATE('01-APR-2006','dd-MON-yyyy')) TABLESPACE tsa, 
	  PARTITION sales_q2_2006 VALUES LESS THAN (TO_DATE('01-JUL-2006','dd-MON-yyyy')) TABLESPACE tsb, 
	  PARTITION sales_q3_2006 VALUES LESS THAN (TO_DATE('01-OCT-2006','dd-MON-yyyy')) TABLESPACE tsc, 
	  PARTITION sales_q4_2006 VALUES LESS THAN (TO_DATE('01-JAN-2007','dd-MON-yyyy')) TABLESPACE tsd);

	CREATE INDEX ix_t1_col1 ON t1(col1) TABLESPACE users STORAGE (INITIAL 20K NEXT 20k);
	DROP INDEX ix_t1_col1;

	CREATE UNIQUE INDEX uq_t1_col1 ON t1(col1);		- create a unique index explicitly

	select * from dba_indexes where table_name = 't1' and table_owner = 'user1';	- list all indexes for a table
	SELECT * FROM dba_ind_columns where table_name = 't1' and table_owner = 'user1'
		ORDER BY table_owner, table_name, index_name, column_position;	- show indexed columns

	ALTER INDEX ix_name RENAME TO new_name;		- rename index
	ALTER INDEX ix_t1_col1 STORAGE (NEXT 40);	- alter storage parameters
	ALTER TABLE t1 ENABLE PRIMARY KEY USING INDEX;	- change the storage options of the index to enforce the primary key constraint:

	ALTER INDEX ix_t1_col1 REBUILD;

	ALTER INDEX emp_name REBUILD ONLINE;

	ALTER INDEX ix_t1_col1 UNUSABLE;
	ALTER INDEX ix_emp_ename MODIFY PARTITION p2_ix_emp_ename UNUSABLE;

	ALTER INDEX index MONITORING USAGE;		- start monitoring
	ALTER INDEX index NOMONITORING USAGE;

	CREATE INDEX ix_sales_amount ON sales(amount)
	GLOBAL PARTITION BY RANGE(sale_month)
	( PARTITION p_1000 VALUES LESS THAN (1000)
	, PARTITION p_10000 VALUES LESS THAN (10000)
	, PARTITION p_100000 VALUES LESS THAN (100000)
	, PARTITION p_1000000 VALUES LESS THAN (1000000)
	, PARTITION p_greater_than_1000000 VALUES LESS THAN (maxvalue));

	Create .sql file in notepad and open from sqlplus

	  1  CREATE OR REPLACE PROCEDURE skeleton
	  2  IS
	  3  BEGIN
	  4      DBMS_OUTPUT.PUT_LINE('Hello World!');
	  5* END;
	SQL>

	SQL> /

	Procedure created.

	SQL>

	SQL> SET SERVEROUTPUT ON;
	SQL> EXECUTE skeleton;

	SQL*Plus assures you the procedure executed successfully:

	PL/SQL procedure successfully completed.

	SQL> BEGIN
	  2    SKELETON;
	  3  END;
	  4  / 

	PL/SQL procedure successfully completed.

	SQL> SET ARRAYSIZE 1
	SQL> SET MAXDATA 60000
	SQL> SHOW ERRORS PROCEDURE proc1

	create or replace package App1dbPackage 
	as 
		type Appcursor is ref cursor; 
		procedure App1Selectproc ( Appcursor1 OUT Appcursor);
		procedure App1Deleteproc;
	end App1dbPackage;

	create or replace package body App1dbPackage as
	procedure App1Selectproc (Appcursor1 OUT Appcursor)
		IS
		BEGIN
			open Appcursor1 for
				 select a.upc_cd, a.sku_num, b.desc, b.class_cd, b.itm_price
					from UPC_AUDIT a  inner JOIN ITEM b	on b.itm_cd = substr(a.sku_num,1,8)
					where a.xfer_dt_time is null
					order by a.sku_num;
		END App1Selectproc;

	procedure App1Deleteproc
		IS
		BEGIN
			update UPC_AUDIT
				set xfer_dt_time = current_date
					where xfer_dt_time is null;
			commit;
		END App1Deleteproc;
	END App1dbPackage;

	CREATE OR REPLACE TRIGGER DeleteCustomer
	BEFORE DELETE ON Customer
	FOR EACH ROW
	BEGIN
	INSERT INTO CustomerHistory
	VALUES(:Old.CUSTOMERID, :Old.LastName, :Old.FirstName);
	END DeleteCustomer;

	ALTER TRIGGER trig1 ENABLE/DISABLE;
	ALTER TABLE t1 ENABLE/DISABLE ALL TRIGGERS;

	SQL> SELECT ((3*4)+5)/3 FROM DUAL;	- returns 5.66666667

	SELECT * FROM RECYCLEBIN;	-- synonym
	SELECT * FROM USER_RECYCLEBIN;	-- view

	Numeric
	PLS_INTEGER or BINARY_INTEGER	Signed integer in range -2,147,483,648 through 2,147,483,647, represented in 32 bits
	BINARY_FLOAT			Single-precision IEEE 754-format floating-point number
	BINARY_DOUBLE			Double-precision IEEE 754-format floating-point number
	NUMBER				Fixed-point or floating-point number with absolute value in range 1E-130 to (but not including) 1.0E126
		DEC, DECIMAL, or NUMERIC	Fixed-point NUMBER with maximum precision of 38 decimal digits
		DOUBLE PRECISION or FLOAT	Floating-point NUMBER with maximum precision of 126 binary digits (approximately 38 decimal digits)
		INT, INTEGER, or SMALLINT	Integer with maximum precision of 38 decimal digits
		REAL				Floating-point NUMBER with maximum precision of 63 binary digits (approximately 18 decimal digits)
		
	Character
	CHAR		Fixed-length character string with maximum size of 32,767 bytes
	VARCHAR2	Variable-length character string with maximum size of 32,767 bytes
	RAW		Variable-length binary or byte string with maximum size of 32,767 bytes, not interpreted by PL/SQL
	NCHAR		Fixed-length national character string with maximum size of 32,767 bytes
	NVARCHAR2	Variable-length national character string with maximum size of 32,767 bytes
	LONG		Variable-length character string with maximum size of 32,760 bytes
	LONG RAW	Variable-length binary or byte string with maximum size of 32,760 bytes, not interpreted by PL/SQL
	ROWID		Physical row identifier, the address of a row in an ordinary table
	UROWID		Universal row identifier (physical, logical, or foreign row identifier)	
	
	Boolean
	BOOLEAN		Stores True, False or Null
	
	Date/Time
	DATE			contains the datetime fields YEAR, MONTH, DAY, HOUR, MINUTE and SECOND. Size is fixed at 7 bytes
	TIMESTAMP		Year, month and day values of date, as well as hour, minute and second values of time	
	YEAR			-4712 to 9999 (excluding year 0)	
	MONTH			01 to 12	
	DAY			01 to 31
	HOUR			00 to 23
	MINUTE			00 to 59
	SECOND			00 to 59.9(n), where 9(n) is the precision of time fractional seconds
	TIMEZONE_HOUR		-12 to 14 (range accommodates daylight savings time changes)
	TIMEZONE_MINUTE		00 to 59
	TIMEZONE_REGION		Found in the dynamic performance view V$TIMEZONE_NAMES
	TIMEZONE_ABBR		Found in the dynamic performance view V$TIMEZONE_NAMES
	

	
	BFILE	Used to store large binary objects in operating system files outside the database.	Cannot exceed 4 GB
	BLOB	Used to store large binary objects in the database.					8 to 128 TB
	CLOB	Used to store large blocks of character data in the database.				8 to 128 TB
	NCLOB	Used to store large blocks of NCHAR data in the database.				8 to 128 TB

	ANALYZE TABLE t1 VALIDATE STRUCTURE;		- throws an error if the structure is corrupt
	ANALYZE TABLE emp VALIDATE STRUCTURE CASCADE;	- validate dependent objects (like indexes) as well
	ANALYZE TABLE emp VALIDATE STRUCTURE CASCADE FAST;	- checks for corruption faster using an optimized algorithm

	PURGE TABLE t1;
	PURGE RECYCLEBIN;

	TRUNCATE TABLE t1 DROP STORAGE;	- the default option, reduces the number of extents allocated to the resulting table to the original 
					setting for MINEXTENTS and freed extents are returned to the system
	TRUNCATE TABLE t1 DROP ALL STORAGE;	- drops the segment				
	TRUNCATE TABLE t1 REUSE STORAGE;	- all space currently allocated to the table remains allocated to it

	MERGE INTO bonuses b USING (SELECT emp_id, salary FROM employees) e ON (b.emp_id = e.emp_id)
		WHEN MATCHED THEN UPDATE SET b.bonus = b.bonus + e.salary*.01
						DELETE WHERE (e.salary > 8000)
		WHEN NOT MATCHED THEN INSERT (b.emp_id, b.bonus) VALUES (e.emp_id, e.salary*.01) WHERE (e.salary <= 8000);

	....
	SAVEPOINT savpt1;
	....
	ROLLBACK TO SAVEPOINT savpt1;

	select emp_name, salary, RANK() OVER (PARTITION BY dept ORDER BY salary) from employees;

	SELECT dept_id, last_name, emp_id, 
		ROW_NUMBER() OVER (PARTITION BY dept_id ORDER BY emp_id) AS emp_no  FROM employees;
		
	DEPT_ID LAST_NAME                 EMPLOYEE_ID     EMP_NO
	------- ------------------------- ----------- ----------
           10 Whalen                            200          1
           20 Hart                              201          1
           20 Fay                               202          2
           30 Raphael                           114          1
           30 Ken                               115          2
           30 Banner                            116          3
	
	SELECT last_name FROM 	(SELECT last_name, ROW_NUMBER() OVER (ORDER BY last_name) R 
			FROM employees) WHERE R BETWEEN 51 and 100;	- returns rows 51 thru 100

	select CAST(col1 AS varchar2(30)) from t1;
	select CAST('22-OCT-2001' AS TIMESTAMP WITH LOCAL TIME ZONE) from t1;

	SELECT TO_DATE( '5 Jan 2011', 'DD MON YYYY' ) FROM t1;	- returns '05-JAN-11'

		TRUNC (125.821)		-- 125
		TRUNC (125.821,2)	-- 125.81
		TRUNC (125.821,-1)	-- 120

	SELECT LPAD('4',3,'0');	- returns '0004'

	SELECT name, LTRIM(name, 'Monitor ') "Short Name" FROM products WHERE name LIKE 'Monitor%';

		NAME		     Short Name
		-----------------    ---------------
		Monitor 17/HR        17/HR
		Monitor 17/HR/F      17/HR/F

	SELECT last_name, first_name FROM hr.employees WHERE SOUNDEX(last_name) = SOUNDEX('SMYTHE');

		LAST_NAME  FIRST_NAME
		---------- ----------
		Smith      Lindsey
		Smith      William

	SELECT NVL(NULL, 'n/a');	- returns 'n/a'

	DELETE FROM t1 A WHERE ROWID > (SELECT min(rowid) FROM t1 B WHERE A.key_values = B.key_values);

	SELECT * FROM employees WHERE ROWNUM < 10;

	SELECT * FROM  
		(SELECT * FROM employees ORDER BY employee_id)  WHERE ROWNUM < 11; - returns the employees with the 10 smallest ids

	SELECT * FROM employees  WHERE ROWNUM > 1;	- returns no rows

	UPDATE t1 SET col1 = ROWNUM;

	DECLARE
	var1 upc.itm_cd%TYPE;	/* Output variables to hold the result of the query: */
	var2 upc.sku_num%TYPE;
	CURSOR Cursor1 IS
		SELECT upc_cd, sku  FROM UPC  WHERE rownum < 1000
			FOR UPDATE
	BEGIN
		OPEN Cursor1;
		LOOP
			 FETCH Cursor1 INTO var1, var2;
			   EXIT WHEN Cursor1%NOTFOUND;
			   DELETE FROM upc WHERE CURRENT OF Cursor1;
			   INSERT INTO upc VALUES(var2, var1);
		END LOOP;
		CLOSE Cursor1;
	END;

	DECLARE
		CURSOR dept_cur IS
		SELECT deptno FROM dept ORDER BY deptno;
	   -- Employee cursor all employees for a dept number
		CURSOR emp_cur (v_dept_no DEPT.DEPTNO%TYPE) IS
		SELECT ename FROM emp WHERE deptno = v_dept_no;
	BEGIN
		FOR dept_rec IN dept_cur LOOP
			dbms_output.put_line('Employees in Department '||TO_CHAR(dept_rec.deptno));
			FOR emp_rec in emp_cur(dept_rec.deptno) LOOP
				dbms_output.put_line('...Employee is '||emp_rec.ename);
			END LOOP;
		END LOOP;
	END;

	DECLARE
	   v_EmpRecord  emp%ROWTYPE;

	DECLARE
	   v_EmpNo  emp.empno%TYPE;

	CONNECT SCOTT@net_service_name
	CONNECT SCOTT/TIGER@net_service_name

	SQLPLUS SCOTT@net_service_name 
	SQLPLUS SCOTT/TIGER@net_service_name 
	sqlplus USER/PASSWORD@//PODS.GATE.COM:1521/SID12
	sqlplus scott/tiger@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=tkyte-pc.us.oracle.com)
	(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ora10g)))

	# SQLNET.ORA Network Configuration File: D:\Oracle\network\admin\sqlnet.ora
	# Generated by Oracle configuration tools.

	NAMES.DEFAULT_DOMAIN = company.com   --> Domain name to attach to names

	SQLNET.AUTHENTICATION_SERVICES= (NTS)

	NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)   --> Order in which to search for names
	

	# TNSNAMES.ORA Network Configuration File: D:\Oracle\network\admin\tnsnames.ora
	# Generated by Oracle configuration tools.

	net_service_name= 
	 (DESCRIPTION= 
	   (ADDRESS=(protocol_address_information))
	   (CONNECT_DATA= 
		 (SERVICE_NAME=service_name))) 

	Sample file:
	DBASPT =
	  (DESCRIPTION =
		(ADDRESS_LIST =
		  (ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.9.21)(PORT = 1521))
		)
		(CONNECT_DATA =
		  (SERVER = DEDICATED)
		  (SERVICE_NAME = dbaspt)
		)
	  )

	extproc_connection_data is a special service name that is used for external procedures. 

	EXTPROC_CONNECTION_DATA.COMPANY.COM =
	  (DESCRIPTION =
		(ADDRESS_LIST =
		  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
		)
		(CONNECT_DATA =
		  (SID = PLSExtProc)
		  (PRESENTATION = RO)
		)
	  )

	STARTUP;	- using SQL*Plus

	SPFILE = /u01/oracle/dbs/test_spfile.ora

	STARTUP PFILE = /u01/oracle/dbs/spf_init.ora

	SHUTDOWN;	- normal shutdown (default), waits for all connected users to disconnect 
	SHUTDOWN IMMEDIATE;	- terminates active transactions, rolls back uncommitted changes and disconnects users
	SHUTDOWN TRANSACTIONAL;	- waits for all current transactions to complete
	SHUTDOWN ABORT;	- terminates all transactions without rolling back and disconnects users, recovery will be required

	select * from product_component_version;

	LSNRCTL STATUS
	LSNRCTL STOP	- stop the listener
	LSNRCTL START	- start

	TNS-12541: TNS:no listener
	TNS-12560: TNS:protocol adapter error
	TNS-00511: No listener

	(PORT=1521)	- the listener is listening for database connections through Oracle Net on port 1521
	(PORT=8080))(Presentation=HTTP)	- the listener is listening for database connections through HTTP on port 8080
	Service "XE" has 1 instance(s) and Instance "XE", status READY - Oracle Database is properly registered with the listener and is ready 
							to accept connections

	PROCESSES = 100
	OPEN_LINKS = 12
	GLOBAL_NAMES = true

	CREATE SPFILE FROM PFILE = '$ORACLE_HOME/work/t_init1.ora';		- create a default spfile from plain-text parameter file
	CREATE SPFILE = 's_params.ora' FROM PFILE = '$ORACLE_HOME/work/t_init1.ora';	- create a non-default spfile

	STARTUP

	spfile = 's_params.ora'

	STARTUP PFILE=new_param.ora

	View				Description
	----				-----------
	V$LOCK				lists the locks currently held by Oracle Database and outstanding requests for a lock or latch
	DBA_BLOCKERS			displays a session if it is holding a lock on an object for which another session is waiting
	DBA_WAITERS			displays a session if it is waiting for a locked object
	DBA_DDL_LOCKS			lists all DDL locks held in the database and all outstanding requests for a DDL lock
	DBA_DML_LOCKS			lists all DML locks held in the database and all outstanding requests for a DML lock
	DBA_LOCK			lists all locks or latches held in the database and all outstanding requests for a lock or latch
	DBA_LOCK_INTERNAL		displays a row for each lock or latch that is being held, and one row for each outstanding request for a lock or latch
	V$LOCKED_OBJECT			lists all locks acquired by every transaction on the system
	V$SESSION_WAIT			lists the resources or events for which active sessions are waiting
	V$SYSSTAT			contains session statistics
	V$RESOURCE_LIMIT		provides information about current and maximum global resource utilization for some system resources
	V$SQLAREA			contains statistics about shared SQL area and contains one row for each SQL string. Also provides statistics about
						SQL statements that are in memory, parsed and ready for execution
	V$LATCH				contains statistics for nonparent latches and summary statistics for parent latches

	SET TRANSACTION ISOLATION LEVEL
	LOCK TABLE
	SELECT ... FOR UPDATE

	select * from V$LOCK;

	EXPLAIN PLAN FOR SELECT col1 FROM t1;

	SELECT PLAN_TABLE_OUTPUT FROM TABLE(DBMS_XPLAN.DISPLAY());
	SELECT PLAN_TABLE_OUTPUT FROM TABLE(DBMS_XPLAN.DISPLAY('MY_PLAN_TABLE', 'st1','TYPICAL'));

	CREATE USER user1 IDENTIFIED BY pwd1;

	select * from dba_users;	- describes all users of the database
	select * from all_users;	- lists all users visible to the current user
	select * from user_users;	- describes the current user

	select * from dba_roles;	- list all roles

	select * from dba_role_privs;	- roles granted to users and roles
	select * from user_role_privs;	- roles granted to current user
	select * from session_roles;	- roles enabled for issuer

	select * from session_privs;	- privileges enabled for issuer

	GRANT dba TO user1 WITH ADMIN OPTION;

	select * from dba_sys_privs;	- system privileges granted to users and roles
	select * from user_sys_privs;	- system privileges granted to the current user

	select * from dba_tab_privs;	- all grants on all objects in the database
	select * from all_tab_privs;	- grants on objects where the user or PUBLIC is the grantee
	select * from user_tab_privs;	- grants on all objects where the current user is the grantee

	SELECT table_name, privilege FROM sys.dba_tab_privs WHERE grantee='PUBLIC';

	SELECT table_name, privilege FROM sys.dba_tab_privs WHERE grantor='SYS';

	CREATE TABLESPACE secutbsp
	DATAFILE '/u01/app/oracle/oradata/orcl/secutbsp01.dbf' SIZE 100M
	ENCRYPTION USING 'AES256' DEFAULT STORAGE(ENCRYPT);

	select * from dba_tablespaces where encrypted = 'YES';
	SELECT t.name, e.encryptionalg algorithm FROM  v$tablespace t, v$encrypted_tablespaces e WHERE t.ts# = e.ts#;

	sqlldr scott/tiger control=loader.ctl

	load data infile 'c:\data\mydata.csv'
	  into table emp
	  fields terminated by "," optionally enclosed by '"'
	  ( empno, empname, sal, deptno )

	load data infile * replace
	  into table departments
	  (  dept     position (02:05) char(4),
		 deptname position (08:27) char(20)
	  )
	begindata
	  COSC  COMPUTER SCIENCE
	  ENGL  ENGLISH LITERATURE
	  MATH  MATHEMATICS
	  POLY  POLITICAL SCIENCE

	LOAD DATA INFILE *
	INTO TABLE load_positional_data
	SKIP 5
	(  data1 POSITION(1:5),
	data2 POSITION(6:15))
	BEGINDATA
	11111AAAAAAAAAA
	22222BBBBBBBBBB

	LOAD DATA INFILE * REPLACE
	INTO TABLE emp
		WHEN empno != ' '
	( empno  POSITION(1:4)   INTEGER EXTERNAL,
	 ename  POSITION(6:15)  CHAR,
	 deptno POSITION(17:18) CHAR,
	 mgr    POSITION(20:23) INTEGER EXTERNAL
	)
	INTO TABLE proj
		WHEN projno != ' '
	(  projno POSITION(25:27) INTEGER EXTERNAL,
	  empno  POSITION(1:4)   INTEGER EXTERNAL
	)

	TRANSPORTABLE=ALWAYS
	FULL=Y

	% rman
	RMAN> CONNECT TARGET "user1@prod AS SYSBACKUP"

	target database Password: pswd
	connected to target database: PROD (DBID=39525561)
	
	RMAN> SHOW ALL;		- show current configuration

	RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

	RMAN> SHUTDOWN IMMEDIATE;
	RMAN> STARTUP FORCE DBA;
	RMAN> SHUTDOWN IMMEDIATE;
	RMAN> STARTUP MOUNT;

	RMAN> BACKUP DATABASE;

	RMAN> BACKUP AS COPY DATABASE;

	RMAN> ALTER DATABASE OPEN;