ORA-39136: cannot specify an SCN on a transportable job

Cause : A taregt SCNw as spceifiedf or a atble i na trasnportalbe jobb y thes tream sor loigcal satndy cmoponenst whic hwas nto the edfaultde SCN ofr thet able.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

This si an itnernale rror.P leaser eporti t to rOacle uspport.

update : 25-09-2017
ORA-39136

ORA-39136 - cannot specify an SCN on a transportable job
ORA-39136 - cannot specify an SCN on a transportable job

  • ora-12680 : Native services disabled but required
  • ora-38770 : FLASHBACK DATABASE failed during recovery.
  • ora-32114 : Cannot perform operation on a null LOB
  • ora-08462 : raw buffer contains invalid decimal data
  • ora-13842 : no SELECT privilege on DBA_SQL_PROFILES
  • ora-38715 : Invalid log number specified in the DUMP FLASHBACK command.
  • ora-23483 : object "string"."string" not allowed in this operation.
  • ora-23501 : refresh template cannot be instantiated for database with compatibilty equal to or less than 8.0
  • ora-19682 : file string not in block media recovery context
  • ora-33336 : (DSSEXIST04A) Analytic workspace string is not attached.
  • ora-12569 : TNS:packet checksum failure
  • ora-31427 : publication string already subscribed
  • ora-30105 : 'string' is not a legal boolean for 'string'
  • ora-24752 : OCI_TRANS_NEW flag must be specified for local transactions
  • ora-16107 : all log data from primary has been processed
  • ora-09351 : Windows 32-bit Two-Task driver unable to allocate shared memory
  • ora-31491 : could not add logfile to LogMiner session
  • ora-12481 : effective label not within program unit clearance range
  • ora-01438 : value larger than specified precision allowed for this column
  • ora-16655 : specified target standby database invalid
  • ora-09929 : GLB of two labels is invalid
  • ora-31510 : name uses reserved prefix CDC$
  • ora-00340 : IO error processing online log string of thread string
  • ora-12414 : internal LBAC error: string Error: string
  • ora-30771 : Cannot add more than one referential constraint on REF column "string"
  • ora-39136 : cannot specify an SCN on a transportable job
  • ora-31215 : DBMS_LDAP: PL/SQL - Invalid LDAP mod value.
  • ora-28155 : user 'string' specified as a proxy is actually a role
  • ora-39218 : type check on object type "string"."string" failed
  • ora-27195 : proxy copy not supported
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.