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: 2834
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: Sun Dec 04 18:35:24 CST 2016

Total time taken to generate the page: 0.14977 seconds