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 ...

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 ...

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 ...