APPSINFODB – Information Technology Group

Finding Solutions for DBA's to smile…….!!!!!!! DBA its just not Administration, its core of customer’s data integrity

  • Blog Stats

    • 34,994 hits
  • Visitors

    free counters
  • Vistors Access

  • Calendar

    February 2009
    M T W T F S S
    « Nov   Mar »
     1
    2345678
    9101112131415
    16171819202122
    232425262728  
  • Archives

  • Authors

Custom Top Setup

Posted by appsinfo on February 24, 2009

create TABLESPACE custom DATAFILE ’E:\oracle\devdata\custom01.dbf’ size 1024mb;

create user XXABC identified by XXABC default tablespace custom temporary tablespace TEMP quota unlimited on custom quota unlimited on TEMP;

grant connect,resource to xxabc

system administrator->security-oracle->register

Database
Username Password Privilege Install Group Description
————————————————————————–
XXCUS CUST Enabled 0 Custom Application

system admiministrator->applications->register

Application ShorName Base Path Description
———– ——– ——— ———–

Bog custom application xxabc xxabc_TOP custom applications

Add the custom schema to a data group. Log into Applications as the System
Administrator and navigate to: Security –> ORACLE –> DataGroup.

For example:

Data Group: Standard
Description: Standard Data Group

Application Oracle ID Description
———————- ———— ———————–
ABC Custom Application APPS Custom Application

It is recommend that you use the STANDARD datagroup and pair the custom schema
with APPS or you can add a new data group. This depends upon your own
requirements.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: