Transport Oracle 11g (11.2.0.3) Database to Oracle 12c (12.1.0.2) Database
### Source DB Server (Oracle 11g)
# make non-system tablespaces read-only
目前分類：Oracle Export/Import (10)
- Feb 02 Tue 2016 11:35
Transport Oracle 11g (11.2.0.3) Database to Oracle 12c (12.1.0.2) Database
- Jun 06 Fri 2014 10:19
Solution to ORA-31684: Object type USER:"TESTUSER" already exists
Problem:
Oracle Data Pump Import Data encounters ORA-31684: Object type USER:"TESTUSER" already exists
- Sep 15 Thu 2011 16:00
EXP-00008: ORA-04031:
Problem: (version of Oracle 8i)
EXP-00008: ORACLE error 4031 encountered
ORA-04031: unable to allocate 4032 bytes of shared memory ("shared pool","oracle/aurora/rdbms/DbmsJavaSYS","joxlod: in ehe","ioc_allocate_pal")
- Sep 07 Wed 2011 14:07
IMP Tables encountered: -bash: syntax error near unexpected token `
- Jul 28 Thu 2011 11:59
Export (Oracle9i) EXP-00056 & ORA-31600 invalid input value EMIT_SCHEMA
Problem:
Encountered EXP-00056 & ORA-31600 invalid input value EMIT_SCHEMA
in Oracle 9.2.0.8
- Jul 25 Mon 2011 11:14
EXP-00003: no storage definition found for segment(2,2)
When the rollback segment tablespace (RBS) was convered from dictionary managed to local managed in Oracle8i, exporting the full database might produce the error of EXP-00003: no storage definition found for segment(2,2).
If this is the case, you can convert the RBS back to the dictionary-managed tablespace by executing the SQL command:
If this is the case, you can convert the RBS back to the dictionary-managed tablespace by executing the SQL command:
- Jul 15 Fri 2011 18:27
EXP-00091 Exporting questionable statistics
|
EXP-00091 Exporting questionable statistics:
- Jul 15 Fri 2011 18:26
EXP-00056: ORA-00904: invalid identifier
EXP-00056: ORACLE error 904 encountered ORA-00904: "SYS"."DBMS_EXPORT_EXTENSION"."FUNC_INDEX_DEFAULT": invalid identifier
Solution:
- Jul 15 Fri 2011 18:23
ORACLE9i Export Errors: exp-00056 & oracle error 942 encountered
- May 12 Wed 2010 11:14
Oracle Data Pump Know-how
-- Create Database Directory
create directory mydump_dir as '/home/orale/mydump'
{{ article.title }}