| General Information |
| Purpose |
This package defines provider-specific administrative operations for the POSIX filesystems managed by "dbms_dbfs_sfs". |
| Source |
{ORACLE_HOME}/rdbms/admin/dbmsfspi.sql |
| First Available |
11.2 |
| Dependencies |
| ALL_OBJECTS |
DDBFS_SFS$_TAB |
| DBA_INDEXES |
DBFS_SFS$_VOL |
| DBA_LOBS |
DBMS_ASSERT |
| DBA_NESTED_TABLES |
DBMS_DBFS_CONTENT |
| DBA_SEGMENTS |
DBMS_DBFS_CONTENT_ADMIN |
| DBA_TABLES |
DBMS_DBFS_CONTENT_PROPERTIES_T |
| DBA_USERS |
DBMS_DBFS_SFS |
| DBFS_SFS$_FS |
DBMS_SPACE |
| DBFS_SFS$_SNAP |
|
|
| Exceptions |
| Error Code |
Description |
| ORA-00054 |
Resource busy and acquire with NOWAIT |
|
| Security Model |
Execute is granted to DBFS_ROLE. Runs as AUTHID DEFINER |
| Subprograms |
|
| |
| BLESSUSER |
| Bless the current session user with sufficient direct privileges to enable them to use various content API
types in their internal tables. This procedure is not meant to be invoked directly, but is a helper function available for use through other packages |
dbms_dbfs_sfs_admin.blessUser(forView IN BOOLEAN DEFAULT FALSE); |
| exec dbms_dbfs_sfs_admin.blessUser; |
| |
| CREATEFILESYSTEM |
| Helper function for repository creation (only for use with dbms_dbfs_sfs.createFilesystem).
Creates a POSIX filesystem repository |
dbms_dbfs_sfs_admin.createFileSystem(
tabid IN NUMBER,
schema_name IN VARCHAR2, -- owner
tbl_name IN VARCHAR2, -- table name
ptbl_name IN VARCHAR2, -- properties table name or NULL
version IN VARCHAR2,
properties IN dbms_content_properties_t
DEFAULT NULL); |
| TBD |
| |
| CREATESNAPSHOT |
| Helper functions for snapshot operations meant to be invoked only from dbms_dbfs_sfs |
dbms_dbfs_sfs_admin.createSnapshot(
store_name IN VARCHAR2,
snap_name IN VARCHAR2,
vol_name IN VARCHAR2 DEFAULT 'main'); |
| TBD |
| |
| DEFAULTTABLESPACE |
| Helper function for repository creation (only for use with dbms_dbfs_sfs.createFilesystem) |
dbms_dbfs_sfs_admin.defaultTablespace(uName IN VARCHAR2) RETURN VARCHAR2; |
| SELECT dbms_dbfs_sfs_admin.defaultTablespace('POSIX_FS_TBS') FROM dual; |
| |
| DELETE_ORPHANS |
| Delete orphaned filesystem/table entries |
dbms_dbfs_sfs_admin.deleteOrphans; |
| exec dbms_dbfs_sfs_admin.deleteOrphans; |
| |
| DROPFILESYSTEM |
| Remove a POSIX filesystem table from the list of known POSIX filesystem tables |
dbms_dbfs_sfs_admin.dropFileSystem(
schema_name IN VARCHAR2,
tbl_name IN VARCHAR2); |
| TBD |
| |
| DROPSNAPSHOT |
| Helper functions for snapshot operations meant to be invoked only from dbms_dbfs_sfs |
dbms_dbfs_sfs_admin.defaultSnapshot(
store_name IN VARCHAR2,
snap_name IN VARCHAR2,
vol_name IN VARCHAR2 DEFAULT 'main'); |
| TBD |
| |
| DROP_ALL_TABLES |
| Drop all POSIX file system tables |
dbms_dbfs_sfs_admin.drop_all_tables; |
| exec dbms_dbfs_sfs_admin.drop_all_tables; |
| |
EXIMREGISTERALL (new 11.2.0.3)  |
| A one-time action to register the SFS entities with the procedural action infrastructure. |
dbms_dbfs_sfs_admin.eximRegisterAll; |
| exec dbms_dbfs_sfs_admin.eximRegisterAll; |
| |
| EXIM_ATTRV (new 11.2.0.3) |
| Export/mport internal helper function |
dbms_dbfs_sfs_admin.exim_attrv(
tabid IN NUMBER,
attrv IN VARCHAR2,
asof IN NUMBER,
vol# IN NUMBER,
goff IN NUMBER); |
| TBD |
| |
| EXIM_FS (new 11.2.0.3) |
| Export/mport internal helper function |
dbms_dbfs_sfs_admin.eximFS(
tabid IN NUMBER,
store_owner IN VARCHAR2,
store_name IN VARCHAR2,
volid IN NUMBER,
snap# IN VARCHAR2,
created IN NUMBER); |
| TBD |
| |
| EXIM_GRANTS (new 11.2.0.3) |
| Export/mport internal helper function |
dbms_dbfs_sfs_admin.exim_grants(tabid IN NUMBER); |
| exec dbms_dbfs_sfs_admin.exim_grants(10); |
| |
| EXIM_SEQ (new 11.2.0.3) |
| Export/mport internal helper function |
dbms_dbfs_sfs_admin.exim_seq(newval IN NUMBER); |
| exec dbms_dbfs_sfs_admin.exim_seq(10); |
| |
| EXIM_SNAP (new 11.2.0.3) |
| Export/mport internal helper function |
dbms_dbfs_sfs_admin.exim_snap(
tabid IN NUMBER,
volid IN NUMBER,
snap# IN VARCHAR2,
snapname IN VARCHAR2,
created IN NUMBER,
deleted IN NUMBER); |
| TBD |
| |
| EXIM_TAB (new 11.2.0.3) |
| Export/mport internal helper function |
dbms_dbfs_sfs_admin.exim_tab(
tabid OUT NUMBER,
schema_name IN VARCHAR2,
table_name IN VARCHAR2,
ptable_name IN VARCHAR2,
version# IN VARCHAR2,
created IN NUMBER,
formatted IN NUMBER); |
| TBD |
| |
| EXIM_TABP (new 11.2.0.3) |
| Export/mport internal helper function |
dbms_dbfs_sfs_admin.exim_tabp(
tabid IN NUMBER,
propname IN VARCHAR2,
propvalue IN VARCHAR2,
typecode IN NUMBER); |
| TBD |
| |
| EXIM_VOL (new 11.2.0.3) |
| Export/mport internal helper function |
dbms_dbfs_sfs_admin.exim_vol(
tabid IN NUMBER,
volid IN NUMBER,
volname IN VARCHAR2,
created IN NUMBER,
csnap# IN NUMBER,
dvolid IN NUMBER,
dsnap# IN NUMBER,
deleted IN NUMBER); |
| TBD |
| |
| GETSTOREID |
| Helper function for looking up a repository id (only for use with dbms_dbfs_sfs.getStoreId) |
dbms_dbfs_sfs_admin.getStoreId(
schema_name IN VARCHAR2,
tbl_name IN VARCHAR2)
RETURN NUMBER; |
| TBD |
| |
| INITFILESYSTEM |
| Initialize a POSIX store. This is a helper function for store initialization (only for use with dbms_dbfs_sfs.initFS) |
dbms_dbfs_sfs_admin.initFileSystem(
schema_name IN VARCHAR2,
tbl_name IN VARCHAR2); |
| TBD |
| |
| INSTANCE_INFO_EXP (new 11.2.0.3) |
| DBFS export/import procedural actions. For internal use only. |
dbms_dbfs_sfs_admin.instance_info_exp(
name IN VARCHAR2,
schema IN VARCHAR2,
prepost IN PLS_INTEGER,
isdba IN PLS_INTEGER,
version IN VARCHAR2,
new_block OUT PLS_INTEGER)
RETURN VARCHAR2; |
| TBD |
| |
| LOBUSAGE |
| Helper function for space usage queries (only for use with dbms_dbfs_sfs.shrinkFS) |
dbms_dbfs_sfs_admin.lobUsage(
schema_name IN VARCHAR2,
tbl_name IN VARCHAR2,
part_name IN VARCHAR2 DEFAULT NULL,
nbytes OUT INTEGER); |
| TBD |
| |
| PARTITION_SEQUENCE |
| Partition the SFS sequence# generator for distributed multi-master environments |
dbms_dbfs_sfs_admin.partition_sequence(
nodes IN NUMBER,
myid IN NUMBER,
newstart IN NUMBER DEFAULT NULL); |
| TBD |
| |
| RECACHE_SEQUENCE (new 11.2.0.3) |
| Adjust the SFS sequence# cache to allow for higher concurrency and file ingest throughput. The default cache size is 20 |
dbms_dbfs_sfs_admin.recache_sequence(newcache IN NUMBER DEFAULT 8192); |
| exec dbms_dbfs_sfs_admin.recache_sequence(1000); |
| |
| REGISTERFILESYSTEM |
Registers an already created POSIX filesystem
(dbms_posix.createFilesystem) in schema "schema_name", table "tbl_name", as a new repository named "repos_name" |
dbms_dbfs_sfs_admin.registerFileSystem(
store_name IN VARCHAR2,
schema_name IN VARCHAR2,
tbl_name IN VARCHAR2,
volume_name IN VARCHAR2 DEFAULT 'main',
snapshot_name IN VARCHAR2 DEFAULT NULL); |
| TBD |
| |
| REVERTSNAPSHOT |
| Helper functions for snapshot operations meant to be invoked only from dbms_dbfs_sfs |
dbms_dbfs_sfs_admin.revertSnapshot(
store_name IN VARCHAR2,
snap_name IN VARCHAR2,
vol_name IN VARCHAR2 DEFAULT 'main'); |
| TBD |
| |
| SCHEMA_INFO_EXP (new 11.2.0.3) |
| DBFS export/import procedural actions. For internal use only. |
dbms_dbfs_sfs_admin.schema_info_exp(
schema IN VARCHAR2,
prepost IN PLS_INTEGER,
isdba IN PLS_INTEGER,
version IN VARCHAR2,
new_block OUT PLS_INTEGER)
RETURN VARCHAR2; |
| TBD |
| |
| SETFSPROPERTIES |
| Update the properties of a POSIX store |
dbms_dbfs_sfs_admin.setFSProperties(
schema_name IN VARCHAR2,
tbl_name IN VARCHAR2,
properties IN dbms_dbfs_content_properties_t); |
| TBD |
| |
| SPACEUSAGE |
| Helper function for space usage queries (only for use with dbms_dbfs_sfs.spaceUsage) |
dbms_dbfs_sfs_admin.spaceUsage(
tbs IN OUT NOCOPY dbms_dbfs_content_properties_t,
schema_name IN VARCHAR2,
tbl_name IN VARCHAR2,
blksize OUT INTEGER,
tbytes OUT INTEGER,
ubytes OUT INTEGER,
fbytes OUT INTEGER,
do_fast IN BOOLEAN DEFAULT FALSE,
useEstimate IN INTEGER DEFAULT 0); |
| TBD |
| |
| SYSTEM_INFO_EXP (new 11.2.0.3) |
| DBFS export/import procedural actions. For internal use only. |
dbms_dbfs_sfs_admin.system_info_exp(
prepost IN PLS_INTEGER,
connectstring OUT NOCOPY VARCHAR2,
version IN VARCHAR2,
new_block OUT PLS_INTEGER)
RETURN VARCHAR2; |
| TBD |
| |
| TBSUSAGE |
| Helper function for space usage queries (only for use with dbms_dbfs_sfs.spaceUsage) |
dbms_dbfs_sfs_admin.tbsUsage(tbs IN dbms_dbfs_content_properties_t) RETURN INTEGER; |
| TBD |
| |
| UNREGISTERFILESYSTEM |
| The repository is removed from the metadata tables, unregistered from the content API,
but the underlying filesystem itself is otherwise untouched |
dbms_dbfs_sfs_admin.unregisterFileSystem(store IN VARCHAR2); |
| exec dbms_dbfs_sfs_admin.unregisterFileSystem('UWSTORE'); |
