Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2009
    Posts
    55

    Unanswered: backup and restore after insert&update table,create&replace VIEW in oracle 9i

    Hi,
    If I insert and update the field of table .
    I also create and replace the VIEW in DB
    I do not want to do cold or hot backup as the database is large and it take
    much time .
    Is there any way to backup and restore about transaction ??
    Please describe in detailed .

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    exp/imp or expdb/impdp or use dbms_metadata package.
    Last edited by LKBrwn_DBA; 12-24-09 at 10:09.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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