Import or load DBF file to Oracle

I use this package to import data from dbase file – foxpro (dbf) to oracle table, –this is spec CREATE OR REPLACE PACKAGE DBF2ORA AS – PROCEDURE TO A LOAD A TABLE WITH RECORDS – FROM A FOXPRO FILE. – – USES A BFILE TO READ BINARY DATA AND DBMS_SQL – TO DYNAMICALLY INSERT INTO [...]

Using the dbms_metadata package to extract all the schema ddl with one call

The DBMS_METADATA package provides the API for setting the environment parameters: DBMS_METADATA.SET_TRANSFORM_PARAM() procedure. The private procedure SetEnvironment() contains all the environment setup code. The procedure is called from the package initialization section. Therefore, it only executes once per session which is all you need. You want to set it up once at the very beginning. [...]

Oracle DBMS_JOB

· Introduction The DBMS_JOB package is known as the job queue. The Oracle job queue provides programs for submitting and executing jobs, changing job execution parameters, and removing or temporarily suspending job execution at predefined times and/or repeated job execution at regular intervals. Users on Oracle 10g and above should use the newer DBMS_SCHEDULER package. [...]

Run Oracle Procedure or Package in Background Process

I had a form that created in form builder. It’s run a procedure that always take some times (15-30 minutes). So users always have to wait until the procedure finish but he can’t do anything else. With this condition, user complain how waste of time to use that form. Then i was thinking if that [...]