Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    Bangalore
    Posts
    8

    Exclamation Unanswered: Converting Unix scripts from Sybase4.x to Oracle9i

    Hello,

    Given below is the Unix script written for the sybase4.x database,

    use master
    go
    sp_dboption cigtmp_db, "select into/bulkcopy", true
    go
    use cigtmp_db
    go
    checkpoint
    go
    use cigtmp_db
    go
    truncate table usn_tbl
    go
    drop index usn_tbl.usn_idx
    go
    quit

    I wanted the oracle equivalent of this script.
    Please advice,

    Thank you,
    - Jay.

  2. #2
    Join Date
    Dec 2003
    Location
    Oklahoma, USA
    Posts
    354
    Jay, you might want to give us more to go on... like what each step in the script accomplishes... then we can help.

    JoeB

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •