Ask TOM Shrinking System. Thank you for your speedy response. When I am executing following query. I got the output of the query as follows. And one more thing I want to confirm is. For the same scenario, I followed following method. Please confirm this is right method or not. I have done cloning of Production instance in Mirror instance. My aim is to decrease the invx. That is, invx. 01. GB and I want to decrease to 4. Gv71Ow8g/T9WkK-sAWdI/AAAAAAAAATM/627Veo3QaI4/s1600/fr4.PNG' alt='Sql Ed Wrote File Afiedt.Buf' title='Sql Ed Wrote File Afiedt.Buf' />GB, Because actual occupied data is 4. GB. I followed following steps. I identified objects exiting in invx. Serious Sam 2 Full Version For Pc. FROM dbaSegments a. WHERE b. fileida. AND segmenttypeINDEX AND ownerINV AND. MTLMATERIALTRANSTEMPN1. File-Append-and-Split-Tool_2.png' alt='Sql Ed Wrote File Afiedt.Buf' title='Sql Ed Wrote File Afiedt.Buf' />MTLMATERIALTRANSTEMPN1. MTLMATERIALTRANSTEMPN2. MTLMATERIALTRANSTEMPN1. MTLMATERIALTRANSTEMPN1. You would need to create a package named FunctionByFour CREATE OR REPLACE PACKAGE SQL ed Wrote file afiedt. CREATE OR REPLACE PACKAGE functionbyfour AS 2. Hi all In oracle I bascially need the first day of the month date. Is there a canned fucntion to do this or some way we can. User system want to access vdatabase to get the database name out by EXECUTE IMMEDIATE select name into vDBname from vdatabase I. MTLMATERIALTRANSTEMPN1. MTLMATERIALTRANSTEMPN1. MTLSYSTEMITEMSBN3. MTLSYSTEMITEMSBU1. MTLSYSTEMITEMSBN4. MTLSYSTEMITEMSBN8. MTLSYSTEMITEMSBN9. MTLSYSTEMITEMSBN6. MTLSYSTEMITEMSBN7. MTLSYSTEMITEMSBN1. Created another tablespace ABC with two datafiles. Moved all the above objects invx. ABC tablespace, after confirmation of moving, issued following command. Manually droped the datafile from OS level. Now I confirmed there is space available after deleting invx. Y0wc-Bx0/Ve6EG2T14jI/AAAAAAAADwU/bykw3BO2c4Y/s1600/regedit4.jpg' alt='Sql Ed Wrote File Afiedt.Buf' title='Sql Ed Wrote File Afiedt.Buf' />Solaris command. Added two more datafiles to INVX tablespace. GB. invx. 15. dbf 2. GB. 5. Finally moved all objects from ABC tablespace to INVX tablespace. MTLSYSTEMITEMSBN1. M next 2. 56. M pctincrease 0 parallel 4 nologging tablespace INVX. I have done like that. Now I aim is achieved. But If monitor through Oracle Enterprise Manager OEM. I am finding invx. INVX tablespace, which is offline. And I want to remove this entry, What is method for removing entry. Please, confirm this is right method or not. Thanks in advance.