DATA Step, Macro, Functions and more

Which is Faster with Oracle, SAS/ACCESS libname or dbload?

Reply
Contributor
Posts: 55

Which is Faster with Oracle, SAS/ACCESS libname or dbload?

In dealing with very large volumes of Oracle data in UNIX which would be faster?

1. Use dbload and deal with the 8 byte field names?

2. Use a LIBNAME connect to Oracle?

Do they both really invoke Oracle's SQLLDR behind the scenes?
Super User
Posts: 5,433

Re: Which is Faster with Oracle, SAS/ACCESS libname or dbload?

DBLOAD is the old fashioned way. I doubt it would faster than using LIBNAME together with Oracle bulk load (which is enabled by using BULKLOAD= option).

/Linus
Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 112 views
  • 0 likes
  • 2 in conversation