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