Size of tablespaces

If you are about to export a file, which is bigger than 32GB, you may encounter errors in oracle database. This is because of the limitation of standard oracle tablespace size to 32GB. If you want to export bigger files, you have to create a BIGFILE - tablespace in oracle. Once you have created such a tablespace and assigned it to a user, you dont have any limitations in size of tablespace.

Last edited Nov 4, 2011 at 4:02 PM by schoeneo, version 2


No comments yet.