Question on Direct-load Insert Without Redo Logging on Tables in Locally Managed Tabl Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Question on Direct-load Insert Without Redo Logging on Tables in Locally Managed Tabl

  1. #1
    Join Date
    Aug 2000
    Chicago IL
    I found this note on Metalink and wanted to ask another question:

    ) have archive log mode on
    2) are using locally managed tablespaces
    3) alter the table to be nologging
    4) use the APPEND hint, I assume they are talking about SQLLDR here, but I'm not sure how to do a hint in SQLLDR off the top of my head. Append is a parm, in terms of append to the table vs. truncate. Often we use truncate, but there are some cases where we use Append. I'm unclear about their use of 'APPEND hint'.

    5)actually, per the last part of the point, it should work for dictionary managed as well, correct?

    The big question is, does it work for noarchivelog mode as well????

    we dont use sqlload to load the data but we insert 14 million rows using a plain insert.
    "High Salaries = Happiness = Project Success."

  2. #2
    Join Date
    Jun 2000
    Madrid, Spain
    not offending but... are you senior dba...?

    anywayz APPEND is a hint for INSERT... AS SELECT ....., with APPEND Hint your insert will be a direct-load insert

    insert /*+ APPEND */ into XXXX select * from ZZZZZ

    this is fast, generates minimum redo, wastes space if your HWM is high

  3. #3
    Join Date
    Apr 2001
    Brisbane, Queensland, Australia
    Just uses the DIRECT=Y parameter from the SQLLDR command line.

    It doesn't matter if you tablespace is DICTIONARY or LOCALLY MANAGED.

    Archivelog and noarchivelog, both stillg enerate redo, it just determines whether the redo logs are archived or not for recovery purposes.
    OCP 8i, 9i DBA
    Brisbane Australia

Posting Permissions

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

Click Here to Expand Forum to Full Width