Naming Conventions

Introduction

The LeasePak setup program allows you to choose between loose and strict naming conventions. During setup, you will be prompted to select one of the following:

S=Strict

L=Loose

N=New Strict

If you have an existing installation of LeasePak version 5.0a or below, select L for Loose to use old naming conventions on existing data and Loose conventions on new data, or select N for New Strict to use old naming conventions on existing data but Strict conventions on new data.

If you have an existing installation of LeasePak version 5.1a or above, or you are installing LeasePak for the first time, select S to use Strict conventions, select L to use Loose conventions, or select N if you have previously used Loose conventions but want to switch to Strict for new data.

Loose and Strict Conventions

Use the following tables to determine the Loose or Strict conventions for each name type.

Naming conventions use regular expressions to denote variable characteristics.

Environment Name

env-name; $ENVNAME

Loose		Strict
Requires	Disallows	Requires	Disallows
[a-z][-0-9_a-z]*		[a-z][-0-9_a-z]*	Directory Names ora* | syb* | sys*| sa | dba | sysdba | sso | dbo lpr* lpc* | lprt*

Database Name and Owner

database-name; $MSIDB_DBNAME
dbo; $MSIDB_OWNER

Loose		Strict
Requires	Disallows	Requires	Disallows
[a-z][0-9_a-z]*	ora* | syb* | sys*| sa | dba | sysdba | sso | dbo $SRVADM | $SRVSO | MSIADMIN | MSIDBA	[a-z][0-9_a-z]* lpr prefix	ora* | syb* | sys*| sa | dba | sysdba | sso | dbo $SRVADM | $SRVSO | MSIADMIN | MSIDBA Unix/Linux account lpc/lpt prefixes

User

user

Loose		Strict
Requires	Disallows	Requires	Disallows
[a-z][0-9_a-z]*	ora* | syb* | sys*| sa | dba | sysdba | sso | dbo $SRVADM | $SRVSO | MSIADMIN | MSIDBA	[a-z][0-9_a-z]* Unix/Linux account	ora* | syb* | sys*| sa | dba | sysdba | sso | dbo $SRVADM | $SRVSO | MSIADMIN | MSIDBA lpr prefix lpc/lpt prefixes

DBMS Roles

$SRVADM
$SRVSO

Loose		Strict
Requires	Disallows	Requires	Disallows
[a-z][0-9_a-z]*	ora* | syb* | sys*| sa | dba | sysdba | sso | dbo $SRVADM | $SRVSO | MSIADMIN | MSIDBA	[a-z][0-9_a-z]* Unix/Linux account	ora* | syb* | sys*| sa | dba | sysdba | sso | dbo $SRVADM | $SRVSO | MSIADMIN | MSIDBA lpr prefix lpc/lpt prefixes

Administrator Roles

$MSIADMIN
$MSIDBA

Loose		Strict
Requires	Disallows	Requires	Disallows
[a-z][0-9_a-z]* Unix/Linux account	Directory Names ora* | syb* | sys*| sa | dba | sysdba | sso | dbo $SRVADM | $SRVSO | MSIADMIN | MSIDBA	[a-z][0-9_a-z]* Unix/Linux account	Directory Names ora* | syb* | sys*| sa | dba | sysdba | sso | dbo $SRVADM | $SRVSO | MSIADMIN | MSIDBA lpr prefix lpc/lpt prefixes

Oracle Tablespace

ora-tsb; $MSIDB_SEG01

Loose		Strict
Requires	Disallows	Requires	Disallows
[a-z][0-9_a-z]*	^.*[0-9][0-9]$ ora* | syb* | sys*| sa | dba | sysdba | sso | dbo	[a-z][0-9_a-z]* lpc/lpt prefixes	^.*[0-9][0-9]$ ora* | syb* | sys*| sa | dba | sysdba | sso | dbo lpr prefix

Disallowed Directory Names

Where specified, both the Loose and Strict naming conventions disallow using the following directory names for other name types:

bin	log
bld	lp
conv	msi
data	ora
dataset	orcs
dlvy	owner
dset	r2k
env	sbin
eop	seed
err	sql
etc	std
exe	syb
gen	sys
host	temp
html	test
lease	tmp
level	v[0-9][0-9][a-z] (for example, v61a)
lib	vertex
live	xlat