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=<friendly_name&g…

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

Kinect your internet of things