ERPstuff - Oracle EBS Community

Hi, I was applying Patch_Oracle_10_2_0_3_win on an Oracle server 10.2.0.1 and unfortunately I missed a step '5.5 Update Oracle Time Zone Definitions'. Then I started following section '8 Removing the Patch Set Software' and in step 5 it says to restore Oracle 10g installation from backup (backup bef...

I have to run an export for a schema which will take approx 1 hour and 15 minutes (may be more) to complete export but now the challenge is that I cannot give that much downtime to the application. So I thought to stop application for a minute and use exp with consisten = Y parameter and then up the...

I have a situation where the dump exported was from a database having character set AL32UTF8 and NLS_NCHAR_CHARTERSET is AL16UTF16.

Now the destination database is having the charcterset as WE8MSWIN1252 and NLS_NCHAR_CHARACTERSET as AL16UTF16.

Any suggestions will be really appreciated.

"inival" column is Long type. I wan to set this value {'XYZ','\\\\pqr\\uvw\\'} I was trying this SQL update table_abc set inival = '{'XYZ','\\\\pqr\\uvw\\'}' where inisection = 'V.L' and the error was set inival = '{'XYZ','\\\\pqr\\uvw\\'}' * ERROR at line 2: ORA-00933: SQL command not pro...