Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Export error: ORA-04063: package body dmsys dbms dm model exp has error     - When Vim create Python scripts, vim autocomplete interpreter and encoding method (Programming)

- MyCAT read and write separation of MySQL (Database)

- Android 4.2 compilation notes (Programming)

- Swift 2.0 brief (Linux)

- Ubuntu buffalo wzr-hp-300nh brush DD-WRT router system (Linux)

- How to fix apt-get update can not add a new CD-ROM error (Linux)

- MySQL log from the library than the main library (Database)

- Remove old kernel on Ubuntu (Linux)

- Linux firewall settings -DNS server articles (Server)

- ARM platform compiler installation Golang (Linux)

- Linux operating system log system (Linux)

- C ++ Supplements - Smart Pointers (Programming)

- Java by Spy Memcached to cache data (Programming)

- Physical structure and process disk IO (Linux)

- Linux kernel modules related to the management Comments (Linux)

- Python Basics Tutorial - lambda keyword (Programming)

- Linux System Getting Started Tutorial: How to Force Change your password at next logon Linux (Linux)

- Install the system cleaning software under Linux: BleachBit 1.4 (Linux)

- Python KNN algorithm of actual realization (Programming)

- 10046 trace only open for a particular SQL statement (Database)

 
         
  Export error: ORA-04063: package body dmsys dbms dm model exp has error
     
  Add Date : 2018-11-21      
         
         
         
  Oracle 11.2.0.2, EBS R12.1.3

Because it is upgraded database systems, retains DMSYS data mining component, but in INVALID status in the library, you can see the query dba_registry.

When exporting metadata error:
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_METADATA", line 1282
ORA-04063: package body "DMSYS.DBMS_DM_MODEL_EXP" has errors
ORA-06508: PL / SQL: could not find program unit being called: "DMSYS.DBMS_DM_MODEL_EXP"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW $ WORKER", line 8398

Approach:
SQL> drop user DMSYS;
SQL> DELETE FROM SYS.EXPPKGACT $ WHERE SCHEMA = 'DMSYS';
SQL> SELECT COUNT (*) FROM DBA_SYNONYMS WHERE TABLE_OWNER = 'DMSYS';

SQL> SET HEAD OFF
SQL> SPOOL /DROP_DMSYS_SYNONYMS.SQL
SQL> SELECT 'Drop public synonym' || SYNONYM_NAME || ';'
     FROM DBA_SYNONYMS WHERE TABLE_OWNER = 'DMSYS';
SQL> SPOOL OFF
SQL> @ / DROP_DMSYS_SYNONYMS.SQL
SQL> EXIT;

We do not have a dmsys
     
         
         
         
  More:      
 
- ThinkPad X201i installation notes Debian 7.5 (Linux)
- Some common Linux commands Study Notes (Linux)
- pkg-config to use (Linux)
- Setting Lns firewall against ARP attacks (Linux)
- How to install or upgrade to the Linux kernel in Ubuntu 4.2 (Linux)
- RedHat / CentOS ext4 partition can not be formatted large supplementary ext4 formatting (Linux)
- Linux AS4 VPN server in conjunction with a firewall perfect (Linux)
- Security implementation of disk data protection under Linux (Linux)
- Redis logging system (Database)
- Linux log management make the system more secure (Linux)
- Oracle 11g users to create, authorize and import dmp file (Database)
- DRBD daily management (Server)
- How to use Linux iptables tool for network sharing (Linux)
- To use iostat display I / O status under Linux (Linux)
- Java interface (Programming)
- RHEL 6.5 KVM analytical use (Server)
- Hazelcast integration with MongoDB (Database)
- Oracle database, some basic grammatical structures (Database)
- In the case of using cgroups Ubuntu 14.04 and Docker (Linux)
- linux firewall configuration (Linux)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.