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.