Taking oracle dump without procedures and functions
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Taking oracle dump without procedures and functions

  1. #1
    Join Date
    Sep 2005
    Posts
    46

    Taking oracle dump without procedures and functions

    Hi all,

    I want to take the dump of a schema. but i need only the tables and the data. I don't want to export procedures, functions or packages. Is there any ways to export a schema like that.


    Please help.


    regards
    Saneesh

  2. #2
    Join Date
    Sep 2005
    Posts
    278
    Exp tables=(tab1, tab2, .....)

  3. #3
    Join Date
    Sep 2005
    Posts
    46

    Taking oracle dump without procedures and functions

    Hi tabreaz,

    Many thanks for your time. Your suggestion is indeed correct. But i have around 800 tables in my schema. BUt relatively small number of packages and procs. So is there any other methods to do that?

    Thanks in advance.

    Regards
    Issac

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    nope

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