Ora1455 indicates how to handle ORA 1455 error when oracle exports data at 11g.

Ora1455 indicates how to handle ORA 1455 error when oracle exports data at 11g.

This exception may occur because the exported User table may have an empty 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, and materialized views.


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 64bit backup EXP-00008: ORACLE error 1455 ORA-01455: conversion column overflow Integer Data Type

Exp username/password file = D: \ aa. dmp owner = pbmis log = D: \ log \ bb. log with the parameter version = the specific oracle11g version number!

Installed oracle 11g R2, new database, script has been generated, and finally appeared ORA-01078 error, how to solve?

$ Oerr ora 1, 1078
01078,000 00, "failure in processing system parameters"
// * Cause: Failure during processing of INIT. ORA parameters
// System startup.
// * Action: Further diagnostic information shoshould be in the error stack.

You have too little information. Check the Installation Log File.
What is your operating system?