Posts

Showing posts from March, 2011

Oracle find all constraints

Find all cascade constraints SELECT lc.table_name loc_table, lc.constraint_name loc_cons, ln.column_name loc_col, lc.r_constraint_name rem_cons, rc.table_name rem_table, rn.column_name rem_column, lc.status, lc.delete_rule, lc.deferrable, lc.deferred, lc.validated FROM user_cons_columns ln, user_cons_columns rn, user_constraints lc INNER JOIN user_constraints rc ON lc.r_constraint_name = rc.constraint_name WHERE (rc.table_name IN ('TABLE_NAME') OR lc.table_name IN ('TABLE_NAME')) AND ln.constraint_name = lc.constraint_name AND rn.constraint_name = rc.constraint_name ORDER BY lc.table_name;

Oracle data pump

Export: 1. Ensure that a directory is setup for the data pump in oracle a. Create the directory on the physical system b. Login via SQLPlus as a dba account i. CREATE DIRECTORY <friendly_name> AS ‘/path/to/dump/dir’; ii. commit; iii. GRANT READ, WRITE ON DIRECTORY <friendly_name> to <schema_user> iv. commit; 2. Run the export a. expdp username/password<@SID> DUMPFILE=<output_filename.dmp> LOGFILE=<logfile.log> DIRECTORY=<friendly_name> Import: 1. Ensure that a directory is setup for the data pump in oracle a. Create the directory on the physical system b. Login via SQLPlus as a dba account i. CREATE DIRECTORY <friendly_name> AS ‘/path/to/dump/dir’; ii. commit; iii. GRANT READ, WRITE ON DIRECTORY <friendly_name> to <schema_user> iv. commit; 2. Run the import a. impdp username/password<@SID> DUMPFILE=<input_filename.dmp> LOGFILE=<import_log.log> DIRECTORY=<friendl

DataScienceToolkit

CataScienceToolkit A collection of the best open data sets and open-source tools for data science, wrapped in an easy-to-use REST/JSON API with command line, Python and Javascript interfaces. Available as a self-contained VM or EC2 AMI that you can deploy yourself. It's essentially a specialized Linux distribution, with a lot of useful data software pre-installed and exposing a simple interface. For full documentation, see http://www.datasciencetoolkit.org/developerdocs.

FlyCam

FlyCam

Kinect your internet of things

How the world will interact with things in the future