Synopsis
CREATE [OR REPLACE ] LIBRARY [schema
.]
library_name
{IS | AS}
'filespec
'
Defines a library (library_name) to hold
external stored procedures. You must specify the IS or AS keyword.
Keywords
- filespec
Specifies an operating system file or raw partition. The syntax is:
'file_name' [SIZE integer
[K | M] ] [REUSE]
- SIZE
Specifies the size of the file. You can optionally specify K or M for
kilobytes (1024) or megabytes (1024 × 1024).
- REUSE
Specifies that if the file already exists, it can be used.
Notes
You must have the CREATE LIBRARY system privilege to create a library
database object in your schema. You must have the CREATE ANY LIBRARY
system privilege to create a library database object in another
schema.
Example
The following example creates a library named “carnegie”:
CREATE LIBRARY carnegie AS '/u01/app/oracle/local/carnegie.so'