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