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

Thread: modifying dump

  1. 01-10-2001, 12:17 PM #1
    portal
    portal is offline Junior Member
    Join Date
    Jul 2000
    Location
    brewster,Newyork
    Posts
    87

    Angry

    folks
    i just want to know can we modify the dumps from an export ?if yes how?and after modifications can we import the same.
    thanks
    sat
    Reply With Quote Reply With Quote
  2. 01-10-2001, 12:25 PM #2
    mhaller
    mhaller is offline Member
    Join Date
    Apr 2000
    Posts
    126

    Wink

    Do not modify an export dump file.
    Reply With Quote Reply With Quote
  3. 01-10-2001, 12:29 PM #3
    Halo
    Halo is offline Moderator
    Join Date
    Apr 2000
    Location
    Baltimore, MD
    Posts
    759
    If you take an export with rows=n, only the 'text' is exported, in which case you can modify it. This done in the case one would want to modify storage parameters, ts names, etc.
    Reply With Quote Reply With Quote
  4. 01-10-2001, 02:27 PM #4
    sonaliak
    sonaliak is offline Senior Member
    Join Date
    Jan 2001
    Posts
    318
    Do you have to do another import to get the rows ???
    Sonali
    Reply With Quote Reply With Quote
  5. 01-10-2001, 02:31 PM #5
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    yea of course import with ignore=y
    Reply With Quote Reply With Quote
  6. 01-10-2001, 03:02 PM #6
    sreddy's Avatar
    sreddy
    sreddy is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Another option is import with show=y which creates the index file which has all the tables and index DDL.
    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