Click Here To Read Post
Which datafile contains my table in Oracle? How do I find it out
You can use the below query to find out the datafile in which a particular t
You can use the below query to find out the datafile in which a particular table is stored, this is an interesting topic when you get into issues like block corruption.
SQL> select a.segment_name, a.tablespace_name, b.file_name from dba_extents a, dba_data_files b where a.file_id = b.file_id and a.segment_name='VBAK';
Do you want to use ICONs while posting a system message? Here is the tip to make it work.
Having an icon like warning/alarm will make the sys
Having an icon like warning/alarm will make the system message more attractive, for example, the same can be done by having the icon code inside the message.
To get to know the icon codes, go to SE16 - ICON -> Download the list into an excel sheet to get the code that you may want to use it in the system message.
Once you have the code with you, post the message text with the code attached to it, for example, @1D@ System will be down in another few minutes time, please log off.
it is an interesting tip, have you guys ever thought of auto forwarding the emails coming into your SAPOffice Inbox?
Use SO36 transaction to
Use SO36 transaction to achieve the same, input values are self-explanatory, I guess, I need not spend time in explaining each and every input field.
Has SE38 Tcode access been restricted in Production environment?
Here is the easy way to see/execute any program.
Goto SM36(yes, you sh
Goto SM36(yes, you should have access to this tcode)
Give some Job name say 'Test Job' then enter, in Program and Variant screen, give the Program/Report you want to see or execute, then Save.
©Copyright 2018. Designed & developed by - Qualy5 Business Solutions