Name

CREATE LIBRARY

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'
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset