3 Replies - 3848 Views - Last Post: 23 June 2006 - 09:40 AM Rate Topic: -----

#1 fyrestorm  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 10
  • View blog
  • Posts: 3,113
  • Joined: 04-April 02

sqlldr

Posted 07 June 2006 - 10:36 AM

I'm wanting to use sqlldr to load data into a table from a file.

I want however to empty the table that i'm loading data into before i load data into it.

Is there a way to do that from within the LOAD DATA command?
Is This A Good Question/Topic? 0
  • +

Replies To: sqlldr

#2 Pink-eye  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 4
  • Joined: 10-June 06

Re: sqlldr

Post icon  Posted 10 June 2006 - 06:22 PM

doesnt look like it
sqlldr help=y

That doesnt show anything that could be of use for you in this case.
Was This Post Helpful? 0
  • +
  • -

#3 fyrestorm  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 10
  • View blog
  • Posts: 3,113
  • Joined: 04-April 02

Re: sqlldr

Posted 23 June 2006 - 08:44 AM

i found a work around, before i schedule the sqlldr script to run, i'm running a script that truncates the table....thanks for looking into it though
Was This Post Helpful? 0
  • +
  • -

#4 Pink-eye  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 4
  • Joined: 10-June 06

Re: sqlldr

Posted 23 June 2006 - 09:40 AM

ah , too bad there isnt a simple direct command for it.

thanks for sharing ^^
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1