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

Thread: EXPORT

  1. 09-24-2001, 03:42 PM #1
    elaine3839
    elaine3839 is offline Senior Member
    Join Date
    May 2001
    Posts
    285
    When use export in User mode using the command

    exp scott/tiger file=scott.dmp owner=scott grants=Y rows=Y compress=y

    If user Scott has tables in more than 1 Oracle instances, then how should we specify which instance we are trying to export? Or everything that belongs to Scott will be exported?

    Thanks!
    Reply With Quote Reply With Quote
  2. 09-24-2001, 03:51 PM #2
    sambavan
    sambavan is offline Senior Advisor
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Originally posted by elaine3839
    When use export in User mode using the command

    exp scott/tiger file=scott.dmp owner=scott grants=Y rows=Y compress=y

    If user Scott has tables in more than 1 Oracle instances, then how should we specify which instance we are trying to export? Or everything that belongs to Scott will be exported?

    Thanks!
    exp scott/tiger@instance1 ...

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!

    Reply With Quote Reply With Quote
  3. 09-24-2001, 03:54 PM #3
    elaine3839
    elaine3839 is offline Senior Member
    Join Date
    May 2001
    Posts
    285
    It's now working... Thanks!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width