Home » SQL & PL/SQL » SQL & PL/SQL » Compress pages and the truncate free spaces
Compress pages and the truncate free spaces [message #242027] Thu, 31 May 2007 07:36 Go to next message
valckeb
Messages: 1
Registered: May 2007
Location: france
Junior Member
Hi

i want to create an alert which will

shrink a transaction log

I would like to shrink the database with this option
)Compress pages and the truncate free spaces from the file
) but I have no idea for the syntax

use Audit5
Go
DBCC SHRINKFILE (Audit5,20000)
GO



Re: Compress pages and the truncate free spaces [message #242028 is a reply to message #242027] Thu, 31 May 2007 07:40 Go to previous message
pablolee
Messages: 2844
Registered: May 2007
Location: Scotland
Senior Member
That looks like MS SQL Server syntax (and you use Pages which also, I believe is a SQL Server term), this is an Oracle forum
Previous Topic: commit
Next Topic: How many Subqueries can i write?
Goto Forum:
  


Current Time: Tue Feb 28 04:05:39 CST 2017

Total time taken to generate the page: 0.14121 seconds