Direct Path Limitations?

Direct Path Limitations?

Post by Joe Silv » Tue, 15 Jun 1999 04:00:00



Hello,

Can anyone tell me what are the restrictions on using direct path? Can
you use things like substr and to_date?

Thanks,

Joe

 
 
 

Direct Path Limitations?

Post by Mark Gumb » Thu, 17 Jun 1999 04:00:00


You cannot use any oracle functions when using direct path because the
loader loads directly into data files and bypasses the database completely.

M


>Hello,

>Can anyone tell me what are the restrictions on using direct path? Can
>you use things like substr and to_date?

>Thanks,

>Joe


 
 
 

1. Equivalent of Direct Path Insert with nologging

What is the SQL server equivalent of Oracle's direct path insert feature.
i.e. insert into table /* + append +/ select * from another table. We are
looking at the fastest way to copy a few million rows from one table to
another without getting into undo/redo space problems.

2. Database format of the German phonebook from DeTeMedien

3. Direct Path Interface through OCI

4. script needed!

5. SQLLoader with direct path?

6. Extended Properties for Stored Procedure Objects

7. parallel partitioned direct-path insert

8. SQLLDR direct path load generating redo log files

9. SQL*Loader Direct Path Problem ? (ORA-02352)

10. SQL*Loader with Direct Path

11. Sqlldr direct path and High Water Mark

12. checkpoint affecting sqlldr direct path