DBMS_COMPRESSION

All posts relating to Oracle database administration.

Moderator: Tim...

DBMS_COMPRESSION

Postby jnrpeardba » Tue Sep 18, 2012 10:32 am

Hi Tim,

hopefully this is a simple request.

I am looking for the correct syntax to execute dbms_compression.get_compression

I think this is the right syntax, but it throws up errors

Code: Select all
EXECUTE DBMS_COMPRESSION.GET_COMPRESSION_RATIO(OWNNAME=>'CDI',TABNAME=>'converted_documents',SAMPLING_PERCENT=>10);

ERROR at line 1:
ORA-06550: line 1, column 100:
PLS-00103: Encountered the symbol ";" when expecting one of the following:
) , * & = - + < / > at in is mod remainder not rem
<an exponent (**)> <> or != or ~= >= <= <> and or like like2
like4 likec between || multiset member submultiset
The symbol ")" was substituted for ";" to continue.

Can you point out what I have done wrong

I've never had to use this before, and searching around for an example has not brought me any further forward

Many thanks
jnrpeardba
Advisor
 
Posts: 392
Joined: Wed May 04, 2011 3:14 pm

Re: DBMS_COMPRESSION

Postby Tim... » Tue Sep 18, 2012 3:47 pm

Hi.

According to the docs there are a bunch of mandatory input and output parameters you've not specified.

http://docs.oracle.com/cd/E11882_01/app ... ARPLS65601

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17962
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 8 guests

cron