Skip to main content
3 of 5
edited tags
user avatar
user avatar

How can I restore a 10.91G table in Oracle Express?

I've received a .dmp file of an enterprise database, but currently only have access to a free version of Oracle. I would ultimately like to import the data to PostgreSQL. But currently am wondering if there's a way to restore the largest table (10.91G) in chunks if need be, so I can export its contents to csvs to import into PostgreSQL.

The largest Tablespace I've been able to create so far was 10500M, the command: CREATE TABLESPACE test DATAFILE 'test.dbf' SIZE 10600M ONLINE; produced error ORA-12953: The request exceeds the maximum allowed database size of 11 GB

raphael
  • 559
  • 1
  • 4
  • 20