netca , dbca
Connect as SYSTEM.
CREATE USER username IDENTIFIED BY apassword;
GRANT CONNECT TO username;
GRANT SELECT [, INSERT] [, UPDATE] [, DELETE] on schema.table TO username;
For example, in the following example, benefits table has a column called v_status. This exp command will export only the rows that contains “INVALID” as value in the v_status column.
$ exp hradmin/mypassword TABLES=benefits query=\"where v_status=\'INVALID\'\" .. About to export specified tables via Conventional Path ... . . exporting table BENEFITS 20783 rows exported
SQL*Loader (sqlldr) is the utility to use for high performance data loads. The data can be loaded from any text file and inserted into the database.
~/Library/Application Support/iPhone Simulator
Objective-C Cheat Sheet and Quick Reference