Translate this Page


Sometime we need to move Temporary Files to other location. This steps will guide you how to do that easily and safety ;)

1. Login as SYSDBA
2. Check the Tempfile status

SQL> SELECT v.file#, t.file_name, v.status
 2  FROM dba_temp_files t, v$tempfile v
 3  WHERE t.file_id = v.file#;

 FILE#     FILE_NAME                 STATUS
---------- ------------------------- -------
 1         /u01/temp01.dbf           ONLINE
 2         /u02/temp02.dbf           ONLINE
 3         /u02/temp03.dbf           ONLINE

3. Make OFFLINE the tempfile that need to move Continue reading »


After we assigning some responsibilities to a user in Oracle E-Business Suite. Unfortunately when user login to the system, he can’t found the responsibilities that he want in the web navigator. This problem usually happen after upgrading or patching.

To solve this problem :

1. Set the role_end_date to null in the wf_local_user_roles.
The sql used will depend on the responsibility missing. For example for the System Administrator responsibility, type in the following:

UPDATE wf_local_user_roles
 SET role_end_date = NULL

Continue reading »

© 2012 LevICORP's webnote Suffusion theme by Sayontan Sinha