Processing of ORA-1455 errors reported when Oracle 11g exports data
About the handling of ORA-1455 errors when Oracle 11g exports data, this exception may occur because the exported User table may have a NULL data table.
First:
View:
SQL> show parameter deferred_segment_creation;
If this parameter is set to TRUE, set this parameter to FALSE;
In sqlplus, run the following command:
SQL> alter system set deferred_segment_creation = false;
Then:
You can manually allocate Extent for data tables, indexes, materialized views, etc.
SQL> Select 'alter table' | table_name | 'allocate extent; 'from user_tables where num_rows = 0
Copy the query results for SQL Execution.
Finally:
Data export test:
Exp test/test @ dbtest file = c: \ dd. dmp log = c: \ dd. log grants = y
Data can be exported successfully!
Oracle 11g installation manual on RedHat Linux 5.8 _ x64 Platform
Installing Oracle 12C in Linux-6-64
Install Oracle 11gR2 (x64) in CentOS 6.4)
Steps for installing Oracle 11gR2 in vmwarevm
Install Oracle 11g XE R2 In Debian