Previous Next JavaScript must be enabled to correctly display this content

## 3 Namespace Management

A namespace defines a group of tables, within which all of the table names must be uniquely identified. This chapter describes namespaces and how to create and manage the namespaces in Oracle NoSQL Database.

Namespaces permit you to do table privilege management as a group operation. You can grant authorization permissions to a namespace to determine who can access both the namespace and the tables within it.

Namespaces permit tables with the same name to exist in your database store. To access such tables, you can use a fully qualified table name. A fully qualified table name is a table name preceded by its namespaces, followed with a colon (:), such as `ns1:table1`.

All tables are part of some namespace. There is a default Oracle NoSQL Database namespace, called `sysdefault`. All tables are assigned to the default `sysdefault` namespace, until or unless you create other namespaces, and create new tables within them. You cannot change an existing table's namespace. Tables in `sysdefault` namespace do not require a fully qualified name and can work with just the table name. For example, to access a table in `sysdefault` namespace, you can just specify `table1` instead of `sysdefault:table1`.

Note:

In a store that was created new or was upgraded from a version prior to 18.3, all the tables will be part of `sysdefault` namespace.

This chapter contains the following topics:

- CREATE NAMESPACE Statement
- SHOW NAMESPACES Statement
- DROP NAMESPACE Statement
- Namespace Resolution
- Namespace Scoped Privileges
- Granting Authorization Access to Namespaces