SQL*Loader is a bulk loader utility used for moving data from external files(flat files) into the Oracle database. SQL*Loader reads from a data file(s)(usually a flat file) and a control file(file that contains description of the data to be loaded and it has nothing to do with database control files) . During loading , process [...]
Archive for the ‘Oracle Utilities’ Category
4 May
Scheduling Job using DBMS_JOBS
Create a Job (run it every day) VARIABLE v_jobnum NUMBER; BEGIN dbms_job.submit(:v_jobnum, ‘MY_STORED_PROCEDURE;’, sysdate,’sysdate+1′); END; print v_jobnum BEGIN DBMS_JOB.SUBMIT(JOB => :jobnumber, WHAT => ‘DBMS_STATS.GATHER_DATABASE_STATS(options => ”GATHER AUTO”);’, NEXT_DATE => to_date(’11:30 01/23/06′,’HH24:MI MM/DD/YY’), INTERVAL => ‘SYSDATE + 1′); COMMIT; END; Running Existing Job While the point is to automate jobs, occasionally you may find you need [...]
26 Mar
EXPDP and IMPDP
Detailed Documentation of EXPDP Detailed Documentation of IMPDP Data Pump is server-based, rather than client-based, dump files, log files, and SQL files are accessed relative to server-based directory paths. Data Pump requires you to specify directory paths as directory objects. A directory object maps a name to a directory path on the file system. SQL> [...]
25 Mar
EXP and IMP Utilities
Command line EXP utility example for export of HR schema exp fzafar/123@orcl file=c:\source\hr.dmp log=c:\source\hr.log buffer=100000 owner=HR CONSISTENT=Y DIRECT=Y IMP utility example to import only two tables in another schema HR_DUP imp fzafar/123@orcl fromuser=HR touser=HR_DUP buffer=100000 file=c:\source\hr.dmp log=c:\source\hr_dup Tables=Jobs,Locations Export Parameters This section contains descriptions of some of the Export command-line parameters. BUFFER Default: operating system-dependent. [...]
24 Mar
Using LogMiner
Oracle LogMiner, which is part of Oracle Database, enables you to query online and archived redo log files through a SQL interface. Because LogMiner provides a well-defined, easy-to-use, and comprehensive relational interface to redo log files, it can be used as a powerful data audit tool, as well as a tool for sophisticated data analysis. [...]
