Question on Direct-load Insert Without Redo Logging on Tables in Locally Managed Tabl
DBAsupport.com 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
    Location
    Chicago IL
    Posts
    586
    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
    Location
    Madrid, Spain
    Posts
    7,447
    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
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    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