Haibo's Blog

Google

Tuesday, November 11, 2008

SAP tp u(ncondional) options

The u stands for unconditional force ( how hard you want to force the request into the system - do you want to overwrite without warnings, or softly try to load the objects).
0: Called a overtaker; change request can be imported from buffer without deleting it and then uncoditional mode 1 is used to allow another import in the correct location.
1: If U1 is used with the export then it ignores the correct status of the command file; and if it is used with import then it lets the user import the same change request again.
2: When used with tp export, it dictates the program to not to expand the selection with TRDIR brackets. If used in tp import phase, it overwrites the originals.
3: When used with tp import, it overwrites the system-dependant objects.
5: During the import to the consolidation system it permits the source systems other than the integration system.
6: When used in import phase, it helps to overwrite objects in unconfirmed repairs.
8: During import phase it ignores the limitations caused by the table classification.
9: During import it ignores that the system is locked for this kind of transport.

Thursday, November 06, 2008

A useful link to solve xp startup errors

Tuesday, November 04, 2008

Oracle DBA Operation: change archivelog mode

Change database archivelog mode
1. be sure to stop database firstly: 
sqlplus /nolog
conn / as sysdba
shutdown immediate
2. startup mount database without open database instance
startup mount
3. change the archivelog mode
alter database noarchivelog;
or
alter database archivelog;
4. open database
alter database open;

You can query archivelog mode by using
select log_mode from v$database;