This probably isn't the problem but before you use UTL_FILE you must set the UTL_FILE_DIR init.ora parameter to define which directories the package can write to
You could use one of the Oracle Precompilers or the PL/SQL file I/O built-in package UTL_FILE to read the file and then perform inserts into the appropriate table. SQL*Loader is probably easiest unless you want to do some pretty complicated data cleansing etc.
I'm think I understand your question. There is not as I understand it a database directory. An Oracle database consists of a series of data files and these can be stored anywhere you want on the file system of the machine where the RDBMS is located. However a cold backup of database will...
If it is not possible to use CREATE TABLE...AS SELECT then
use DBMS_SQL to create a table. The following procedure will execute a ddl statement as per the SQL string you pass it:
PROCEDURE any_ddl (sql_string IN VARCHAR2)
IS
c1 INTEGER;
BEGIN
c1 := dbms_sql.open_cursor...
Quest Software offer loads of Oracle monitoring tools and they can be downloaded for evaluation purposes. Obviously they're not as cheap as SQL*Plus reports but much nicer to work with. If you're after scripts http://www.orsweb.com is always a good place to start.
I definately reckon the SAFE...
Hints are available in version 7 of Oracle but the optimiser will ignore them if the init.ora paramter optimiser_mode is set to RULE. Bear in mind that the follwing will prevent the optimiser from using an index:
-Using functions on the indexed column(s) in the WHERE clause
-Performing NULL...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.