DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2000
    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
    Louisville KY
    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

    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


  4. #4
    Join Date
    Apr 2001

    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
    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
    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.