Import/ Export limitations
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Import/ Export limitations

  1. #1
    Join Date
    Jul 2005
    Posts
    7

    Import/ Export limitations

    Due to space limitations on my development server, I need to create a smaller export of my Oracle Tables.

    I can identify 40 - 75 tables which I can reduce the amount of data (to only contain data from the past 2 years). I can use the IMPORT parameters: TABLES = AND QUERY = to limit the data in these Tables.

    However, I still have 850 more tables I need to export/ import in another Export File. Is there a way to limit this export so it doesn't contain the 40-75 tables I plan on exporting seperately??

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    you will have to list all the tables you want to export individually

  3. #3
    Join Date
    Jul 2005
    Posts
    7
    Thanks.

    Do you know if there is a limit to the number of tables I can specify in the EXPORT parameter file?

  4. #4
    Join Date
    Oct 2005
    Location
    Indianapolis
    Posts
    100
    I've exported over 2000 before
    "False data can act only as a distraction. Therefore. I shall refuse to perceive you." - Bomb #20

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