9i External tables for ETL !!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: 9i External tables for ETL !!

  1. #1
    Join Date
    Jul 2003
    Posts
    323

    9i External tables for ETL !!

    Looking at a daily upload of 3 dim. tabs. using X'tnl tables. Db:9.2.0.4 on Sol 2.8
    Records: 8-10 Million/each !!

    Plan to automate the file ref. as it comes in. This is a 5TB db. so if anyone has done this and if any issues would appreciate knowing esp. with regards to backup of the db which I do not forsee !!



  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Use RMAN
    !!!!!!!!!!!!
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Jul 2003
    Posts
    323
    tx -sd !!

    Right now the db is in noarch mode backed up approx. every 90 days by a vendor like Syncsort.

    However was wondering if someone had a setup like this as currently sqlldr is used!!


  4. #4
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Nothing wrong with noarch mode in a DWh environment, as long as your ETL + front end metadata is then kept in a seperate database under arch mode.

    A useful practice (maybe idealistic) is that after the ETL procedure has performed a nologging op like this then it kicks off an RMAN incremental backup (maybe single channel to limit production impact).
    Last edited by slimdave; 02-15-2005 at 04:11 PM.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Originally posted by cruser3
    tx -sd !!

    Right now the db is in noarch mode backed up approx. every 90 days by a vendor like Syncsort.

    Isnt Syncsort a awk like tool...?

  6. #6
    Join Date
    Jul 2003
    Posts
    323
    Syncsort is a firm in the backup/storage arena - offers tape backup and other storage solutions to firms with VLDB's/large envs.
    website:syncsort.com

    Again my query - does anyone have a setup of this sort and issues ?


  7. #7
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    What is the backup time for 5 TB DB by Syncsort?

    Tamil

  8. #8
    Join Date
    Jul 2003
    Posts
    323
    The backup time is 36 Hrs. - if everything goes well - i.e no problems with NBU/Tape Loaders !!


  9. #9
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    we used syncsort sort of DWH support tool for ETL processes

    http://www.syncsort.com/sort/infosu.htm

    Guess you mean that backup express app made by the same company

  10. #10
    Join Date
    Jul 2003
    Posts
    323
    Yeah..for reasons of client confidentiality cannot post vendors name hence the comparison to syncsort. Ayways has anyone used 'xternal tables to implement the ETL solution as I described ?




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