October 10, 2013

How to take backup of Siebel Tables?

This article explains how to take backup of Siebel Tables or any other table in Oracle database. It is a good practice to take backup of data before making any changes to schema or before updating bulk records. However Siebel does not provide any archiving or data backup solution out of the box.

There are couple of solutions available if you are using oracle database, some of them are:
1. First option is to copy the table with all the data into a new table in same or any other database.As compared with the any other option turnaround time is very less, as this command executes on the server and there is no payload transferred between client and server.

This can be done with the help of create table command with select statement.

CREATE TABLE new_table  AS (SELECT * FROM old_table);
As this is just a SQL command, it only requires credentials which has DDL/DML privileges, which is usually granted to SIEBEL database user in Siebel Implementations.

One can also use insert statements to append data.

INSERT INTO table2 SELECT * FROM table1;

These sql are pretty useful if there is need to update the data type of siebel columns or update bulk data. These can be substituted for EIM Export.

2. Using oracle exp imp utilities. This option allows you to take export of data into a dmp file. This tool require you have SYSDBA account.
Read more on: http://docs.oracle.com/cd/B19306_01/server.102/b14215/exp_imp.htm
Time taken to take backup depends upon size of the table in terms of records. This could be a time consuming activity please plan with caution in planning releases.

No comments :

Post a Comment