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 : 27-05-2017
ORA-39136

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

  • ora-14307 : partition contains too many list values
  • ora-31114 : XDB configuration has been deleted or is corrupted
  • ora-34061 : (MSEXECUT11) Session-only values cannot be added to non-unique concat dimension workspace object, or any of its base dimensions.
  • ora-07285 : sksaprd: volume size should not be specified for a disk file.
  • ora-08116 : can not acquire dml enough lock(S mode) for online index build
  • ora-12818 : invalid option in PARALLEL clause
  • ora-27300 : OS system dependent operation:string failed with status: string
  • ora-39768 : only one direct path context top level column array is allowed
  • ora-01500 : failure in getting date/time
  • ora-16169 : LGWR network server invalid parameters
  • ora-39061 : import mode string conflicts with export mode string
  • ora-01062 : unable to allocate memory for define buffer
  • ora-19400 : System type conflict with object SYS.string
  • ora-38785 : Media recovery must be enabled for guaranteed restore point.
  • ora-23471 : template not authorized for user
  • ora-15122 : ASM file name 'string' contains an invalid file number
  • ora-28054 : the password has expired. string Grace logins are left
  • ora-29858 : error occurred in the execution of ODCIINDEXALTER routine
  • ora-01691 : unable to extend lob segment string.string by string in tablespace string
  • ora-07685 : sou2os: supervisor stack set error
  • ora-08452 : specification of E in picture mask is unsupported
  • ora-07407 : slbtpd: invalid exponent.
  • ora-10281 : maximum time to wait for process creation
  • ora-08180 : no snapshot found based on specified time
  • ora-29906 : indextype string.string does not exist
  • ora-13275 : spatial index creation failure on unsupported type
  • ora-36883 : (XSSRF02) The first parameter of an AW single row function cannot be NULL.
  • ora-31162 : element or attribute "string" has no SQLType specified
  • ora-38487 : FUNCTION/PACKAGE/TYPE "string" not allowed in the expression
  • ora-32737 : Hang analysis aborted due to failed memory allocation
  • 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.