1. Create a customer ID. The format for the customer ID will be: two letters-a number-two letters. The first two letters should be the abbreviation of the state of the customer. The number may be random. The last two letters should be a rough abbreviation of the customer's city.
*example- a customer who resides in Battle Creek, Michigan- MI7BC
2. Determine the size of the tablespace we will be renting to the customer. Store the customer ID in SFDC as a note and log the size of the tablespace we will be renting to the customer.
*note- space will be rented in 50mb increments with 35mb reserved for the data and 15 mb for the index.
3. Once the customer ID has been established create a folder, with the same name as the customer ID, on the UW1 server in the c:\CustData directory.
4. Log into SQL plus (user: system) and create the customer tablespace.
*example commands for a 50 m tablespace data file and index creation:
SQL> create tablespace mi7bc_data
2 datafile 'c:\custdata\MI7bc\MI7bc_data.dbf' size 35m
3 autoextend off;
Tablespace created.
SQL> create tablespace mi7bc_index
2 datafile 'c:\custdata\MI7bc\MI7bc_index.dbf' size 15m
3 autoextend off;
Tablespace created.
5. Run DB create to create the campaign database.
6. Generate keys using S:\RegKey32\KeyGen.exe then:
a) Save the keys in SFDC as a Note.
b) Login as the owner user and set the keys in CM.
7. Notify the customer and their DA sales rep so that training can be scheduled.