Import/Export Limitation and Schema Comparison
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Import/Export Limitation and Schema Comparison

  1. #1
    Join Date
    Oct 2000
    Posts
    449
    Hello: I would like to know if there are any filesize limitations on Import/Export. I have a few segments that are larger than 2GB or infact close to 10GB. What is the best way to export these segments or move them to another instance. Secondly I have an instance which is very similar to a prod. The application here is of a different version and I need to compare the schema changes between 2 schemas in these 2 instances.. Is there any short cut way to do this. I mean any oracle tools..
    Thanks, ST

  2. #2
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    If you are moving the tables from one database to another, you should look into transportable tablespaces ifyou are using 8i.

    Another option is cross-network copies (create table a as select * from old_table@other_server.... or copy fromuser append.......).

    If you must use export/import, it can be done using unlabeled tapes, if your tape drives have sufficient capacity. I use this technique in Unix. It is supposed to be available for NT, but I haven't tried it.
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

  3. #3
    Join Date
    Mar 2001
    Posts
    635
    Hi

    For schema comparision you can try using

    Emabarcadero's schema manager.

    About export/Import the max I have been with is about 6 GB of database Information in the dump file.

    Usually when you export use a bigger rollback segment and make the rest of the rollback segment offline.once the dump file is ready when you import it will use the bigger rollback segment to perform the import and you will not run into errors this is what I do for my database.

    In fact I use one rollback segment of about 500 Mega bytes

    Regards,
    Santosh

  4. #4
    Join Date
    Apr 2001
    Posts
    108

    Export file limits

    I seem to remember that Oracle still states that the max .dmp file size should not exceed 2 Gbytes. If anybody has different information please let us know. I've set up scripts to break the dmp file into smaller pieces as I have a few databases who's compressed export files exceed the 2Gbyte limit.

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    With 8i, you can specify multiple files of xM each. For example:
    exp system/manager file=a.dmp, b.dmp filesize=2000M full=y
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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