[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 495
  • Last Modified:

How do you truncade a database in Oracle sqlldr before loading fresh data.

How do you truncade a database in Oracle sqlldr before loading fresh data. I can do this in sqlplus but would prefer to do inthrough sqlldr.
0
rayskelton
Asked:
rayskelton
  • 2
  • 2
1 Solution
 
jwahlCommented:
do you mean truncate TABLE or really DATABASE?
0
 
RainMan82Commented:
  execute immediate 'truncate table tablename;
0
 
RainMan82Commented:

sorry forgot the last part....
   execute immediate 'truncate table tablename';
0
 
rayskeltonAuthor Commented:
Will this work as control file option in sqlldr or is this a command line option?

'truncate table tablename';
0
 
rayskeltonAuthor Commented:
truncate as a control file option works good,
thanks
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now