What are different types of tables in Siebel?

Tables in Siebel can be broadly classified into two types
  • Repository Tables
  • Data Tables

Repository Tables: Tables that are used to store Meta data about Siebel Objects are repository tables. Following are examples of Repository tables
S_APPLET: Stores Siebel Applets information
S_BUSCOMP
: Stores Siebel Business Component Information
S_WFR_PROC:
 Stores Siebel Workflow Process Information
Data Table: Tables that are used to store Siebel User data are known as data tables. They can be further classified into following types
Base Tables: Stores data about various siebel entities such as opportunity, quotes service requests. Following are examples of Base Tables
S_OPTY: Used to store Opportunity Information
S_SRV_REQ: Used to store Service Request Information
S_EVT_ACT: Used to Activities Information
S_DOC_QUOTE: Used to store Quote Information
Extension Tables: These tables are extension of base tables and are connected via implicit join and are used to store custom information for various entities. They have _X suffix to their name
S_OPTY_X: Extension table for opportunities
S_DOC_QUOTE_X: Extension table for quotes
S_EVT_ACT_X: Extension table for activities
Interface Tables: Used export and import data from external applications. They have EIM prefix with table name. Every base table and extension table has its corresponding EIM tables. Examples of EIM Tables are
EIM_OPTY: Opportunity EIM Table
EIM_ACTIVITY: Activities EIM Table
XM Tables: These tables are used where M: M relationships have to be established. These tables have XM suffix after their name. Most of the base tables have corresponding XM tables. Examples of XM Tables are
S_OPTY_XM: XM table for Opportunity
S_DOC_QUOTE_XM: XM table for Quote

  1.                               How to install Oracle 11g Database 

  1. The Oracle Database 11g Release 2 files are broken down into two zip files on the Oracle site. That means you need to download both files, and then expand them into an installation directory. I called my installation directory C:OracleInstall, but you can call it whatever works for you. Here’s a screen shot of the directory after expanding both compressed files (done with WinZip 15).

Uncheck check box and click next

Click on next.

  1. It’s a good idea to provide an email address for security updates no matter what. You can uncheck the box if you don’t want updates via Oracle Support Services. Click the Next button to continue.
  1. Most developers want to Create and configure a database. If that’s your desire, leave the default radio button checked. Click the Next button to continue.
  1. Most developers install their test instance on a desktop or laptop. If that’s your desire, leave the defaultDesktop Class radio button checked. Click the Next button to continue.
  1. These are default settings and generally the easiest to use. I’d suggest you change the Character Set drop down to Unicode. Then, enter a password twice. Oracle requires that you use at least one capital letter and one number in a 6 character or more long password. Click the Next button to continue.
  1. The next screen is a progress bar that checks for prerequisites. You shouldn’t have to do anything here because it automatically advances you to the next dialog screen. This generally takes less than a minute to run but can take two or so. If you’re much beyond 3 minutes there may be a resource problem with your Windows PC or virtual machine.
  1. This shows you all the selected values for the installation. Unless you want to abort the installation, click the Finish button to proceed.
  1. This screen is the main progress bar, and you’ll be here somewhere between 5 and 10 minutes. The downside is that there are some dialogs that will popup during this phase and you need to authorize them, so it’s a bad time to take a break.
  1. The first popup screen requires you to authorize the Java runtime to call home. You should click theAllow Access button to proceed.
  1. When the progress bar starts configuring the instance, failures can occur. The first may occur during the network configuration, which typically happens if you didn’t preconfigure the hosts file. You don’t need to do anything but watch here unless the installer triggers an error.
  1. The following progress bar is launched by the Oracle Database Configuration Assistant. It typically runs without a problem. You don’t need to do anything but watch here unless the installer triggers an error. This takes a few minutes, and unfortunately requires you to stick aroung to again authorize Java.
  1. The second popup screen requires you to authorize the Java runtime to call home. You should click theAllow Access button to proceed.
  1. The third and last popup screen asks you to whether you want to open other scheme. Generally, you should click the OK button to proceed.
  1. The next dialog shows you that the network and database instances are configured. It’s also running the OEM (Oracle Enterprise Manager) installation. You can wait here but it won’t be a long wait.
  1. This is the last dialog and says you’ve installed Oracle Database 11g Release 2 successfully. You can theClose button to complete the installation.

Upgrade Oracle Database from version 11.2.0.2 To 11.2.0.4 and Higher Version


1. Before Upgrading Database we should Take backup of database .If something goes wrong then we can recover it.


2.Download patch file 11.2.0.4 and higher version which you want to upgrade from
oracle partner site.


3. Unzip all file into one folder then install software.


4. Right click on setup.exe and run as Administrator.





Uncheck check box and click next



Click on next.


Click on Skip Software update.



Check install database software only and click next.


Select single instance database installation.






Save the detail and click on install .
Open command prompt and Go to This path and run dbua.bat file.




Gave username and password.













sql>SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;
sql>select name from v$database;
sql> select open_mode from v$database;