Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2012
    Posts
    37

    Unanswered: How to BackUp the schema tables in oracle

    I have a schema name submaster in my oracle databse . The submaster conatins more that 50 tables
    How can oracle create the backup of all the tables and store at a particular location

  2. #2
    Join Date
    Nov 2003
    Posts
    2,934
    Provided Answers: 12
    Use datapump: Data Pump Export
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags: http://www.dbforums.com/misc.php?do=bbcode#code

    Tips for good questions:

    http://tkyte.blogspot.de/2005/06/how...questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

  3. #3
    Join Date
    Mar 2012
    Posts
    37
    can you please post the sql

  4. #4
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    There's an example of the sql statement in the link you were given.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Posting Permissions

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