Previous Next JavaScript must be enabled to correctly display this content

## 2 Working with Namesapce

This chapter provides examples on how to manage namespaces.

A namespace in Oracle NoSQL Database groups tables and ensures that table names are unique within it. It enables table privilege management as a group. You can have multiple tables with the same name across different namespaces. To access these tables, you must use the fully qualified table name. A fully qualified table name begins with a namespace, followed by a table name, separated by a colon (:). For example, `ns1:table1`.

Note:

Namespaces are case-insensitive, so `ns1` or `NS1` are treated as same.

You can create multiple namespaces in your store. Each table belongs to a specific namespace. The default Oracle NoSQL Database namespace is `sysdefault`. You do not need a fully qualified name to access tables in the `sysdefault` namespace. For example, you can access the table by specifying `table2` instead of `sysdefault:table2`.

All namespaces names use standard identifiers, with the same restrictions as tables and indexes:

- Names must begin with an alphabetic character (a-z,A-Z).
- Remaining characters are alphanumeric (a-z, A-Z, 0–9).
- Name characters can include period (.), and underscore (_) characters.
- The maximum name length for a namespace is 128 characters.

Note:

You cannot use the prefix `sys` for any namespaces. The `sys` prefix is reserved. No other keywords are restricted.