DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: export

  1. #1
    Join Date
    Mar 2001
    Location
    south africa
    Posts
    401

    export

    Hi

    Can some one help the following

    1. in export which parameter to include to export only objects of particular user with out data.

    2.is there a way in export to tell to grab 100 rows from each table
    for a particular user


    pls advise

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    RTFM

    rows=no

  3. #3
    Join Date
    Mar 2001
    Location
    south africa
    Posts
    401
    RTFM ????

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    read the flipping manual

  5. #5
    Join Date
    Jan 2001
    Posts
    3,134
    1) You could do a schema level export.
    2) Use the QUERY clause...."Where rownum <101"

    MH
    I remember when this place was cool.

  6. #6
    Join Date
    Mar 2001
    Location
    south africa
    Posts
    401
    thanks davey23uk , I was using rows =n and for some reason it didn't striked me at that point.Thanks

    Thanks Mr.Hanky, i never did some thing like that , let me try


    Thanks

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