1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Child table backup in archiving data of source table:::

Discussion in 'SQL PL/SQL' started by Angappan, Aug 11, 2009.

  1. Angappan

    Angappan Active Member

    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    80
    Hi,

    I am trying with archival data process of a table. how to find and take backup of child table and how to remove the records in the child table and parent table after archival
    kindly tell me.

    thanks
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,345
    Likes Received:
    347
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Describe this "archival data process of a table".
     
  3. Angappan

    Angappan Active Member

    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    80
    hi

    i would like to know,

    1) child for the parent table( source table ) called for archival process.

    reference constraints,

    2) backup of child,

    how to delete child and parent, constraint will reflect right?
     
  4. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,345
    Likes Received:
    347
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    You did not describe this 'archival process' you talk of.

    Please do so.