DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: export required enter key to press

  1. 03-30-2003, 11:40 PM #1
    fordikon
    fordikon is offline Member
    Join Date
    Apr 2001
    Posts
    126

    Angry export required enter key to press

    during export operation it requires ENTER key to press when
    exporting large rows in particular table.

    It wait's till i press ENTER key to continue the exp operation.
    Reply With Quote Reply With Quote
  2. 03-31-2003, 12:48 AM #2
    ggnanaraj
    ggnanaraj is offline Senior Advisor
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    What is the command you are using to export? Are you using interactive export? Post the parameters that you are using when invoking the exp utility.
    Reply With Quote Reply With Quote
  3. 03-31-2003, 12:59 AM #3
    fordikon
    fordikon is offline Member
    Join Date
    Apr 2001
    Posts
    126
    exp system/xxxx@db file=oracle.dmp full=Y log=oracle.log grants=Y indexes=Y CONSISTENT=Y TRIGGERS=Y CONSTRAINTS=Y
    Reply With Quote Reply With Quote
  4. 03-31-2003, 01:17 AM #4
    alapps
    alapps is offline Member
    Join Date
    Jul 2002
    Location
    California
    Posts
    128
    Post your log file - oracle.log

    More info is needed to debug
    alapps

    Fast, Cheap, Reliable... Pick Two(2)
    Reply With Quote Reply With Quote
  5. 03-31-2003, 01:29 AM #5
    ggnanaraj
    ggnanaraj is offline Senior Advisor
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Originally posted by fordikon
    exp system/xxxx@db file=oracle.dmp full=Y log=oracle.log grants=Y indexes=Y CONSISTENT=Y TRIGGERS=Y CONSTRAINTS=Y
    As you are using full database export, grants on a table are always exported, by default.
    http://technet.oracle.com/docs/produ...ch01.htm#17093

    So also for indexes & constraints (default is Yes). You dont' have a param called triggers. Check out the 'consistent' param with the doc referenced above.

    HTH.
    Reply With Quote Reply With Quote
  6. 03-31-2003, 01:44 AM #6
    adewri's Avatar
    adewri
    adewri is offline Oracle Monk
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by ggnanaraj
    You dont' have a param called triggers.
    In 8i and 9i exp utility you have the param called triggers
    Last edited by adewri; 03-31-2003 at 01:54 AM.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!
    Reply With Quote Reply With Quote
  7. 03-31-2003, 02:47 AM #7
    ggnanaraj
    ggnanaraj is offline Senior Advisor
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Originally posted by adewri
    In 8i and 9i exp utility you have the param called triggers
    Document bug it seems?? The PDF document(ver 815) I have downloaded for reference does not have that param but html online (817) doc has it.

    BTW, the html (815) version also does not have this param...
    http://download-east.oracle.com/docs...ch01.htm#34494
    Reply With Quote Reply With Quote
  8. 03-31-2003, 02:56 AM #8
    adewri's Avatar
    adewri
    adewri is offline Oracle Monk
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by ggnanaraj
    Document bug it seems?? The PDF document(ver 815) I have downloaded for reference does not have that param but html online (817) doc has it.

    BTW, the html (815) version also does not have this param...
    http://download-east.oracle.com/docs...ch01.htm#34494
    Quite possible, best way to find out is do exp help=y and see if its there...
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!
    Reply With Quote Reply With Quote
  9. 03-31-2003, 03:21 AM #9
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    trigger=y/n does not work till 8.1.7
    Reply With Quote Reply With Quote
  10. 03-31-2003, 10:36 AM #10
    fordikon
    fordikon is offline Member
    Join Date
    Apr 2001
    Posts
    126
    TRIGGERS=Y parameter was invoked from 8.1.7 and it worked.
    now the query is not related to having triggers=Y or N?.
    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