# oracle install how to
https://www.oratoolkit.ch/knowledge/howto/installation/eeSrv-11g-R2-on-RHEL-6.0-x86_64.php


# oracle stuff
# environment variables may need to be sourced via
# oracle_env.sh

# oracle uses "schemas" versus "databases"

# db locations
~oracle/oradata

# listener.ora manages network connections
~oracle/app/oracle/product/11.2.0/server/network/admin/

# default accounts
SYSTEM - like mysql root (system|systempass)
SYS - don't touch
AS SYSDBA - account wrapper for performing high level administrative tasks

# commands
sqlplus /nolog - enter SQL server via command line
connect user/pass - connect as user with password
select * from global_name - shows current database
select username from all_users - lists all schemas
select column_name from all_tab_columns where table_name =/LIKE 'blah' = shows all columns in a table
select owner, table_name from all_tables where blah like 'D31%' = show all tables and owner within db
select blah from owner.table_name; get data from table


# install workspace manager
$ORACLE_HOME/rdbms/admin (cd here)
sqlplus sys/pass@db as sysdba (connect as system user to database)
SQL>@owminst.plb (run pl/sql doc)
SQL>select dbms_wm.getWorkspace from dual (verify)


# digital-dev


# import issues
https://forums.oracle.com/forums/thread.jspa?threadID=2313088&tstart=-2
http://www.dba-oracle.com/t_export_import_different_releases_of_oracle.htm
http://answers.yahoo.com/question/index?qid=20080521172841AAn5HaP
https://cn.forums.oracle.com/forums/thread.jspa?threadID=2355189

# import command
full=yes table_exists_action=truncate ignore=y