Welcome to Charles Blog

lol..

Backup principles in Oracle Databases

It consists of

* Physical and Logical backups
* Whole database and partial database backups
* Online and offline backups
* RMAN and User-Managed backups
* Physical and Logical Backups:

Physical backups:

In  ‘physical backups’ are backups of physical database files: data files and control files. If you run the database in ARCHIVELOG mode, then the dataase also generates archived redo logs. You can back up the data files, control files, and archived redo logs.

Physical backups are divided into two categories: image copies and backups in a proprietary format. An image copy is  an exact duplicate of a data file,control file, or archived log. You can create image copies of physical files with operating system utilities or the RMAN COPY command, and you can restore them as-is without performing additional processing by using either operating system utilities or the RMAN RESTORE command.

Note: Unlike operating system copies, the RMAN copy command validates the blocks in the file and records the copy in the repository.

The RMAN BACKUP command generates a backup set, which is logical object containing one or more backup pieces. Each backup piece is a physical file in a proprietary, binary format. You must use RMAN to restore this backup set.

Logical Backups:

In contrast to physical,  ‘logical backups’ are exports of schema objects into a binary file. Import and Export are utilities used to move oracle data in and out of oracle schema. Export writes data from and oracle database to binary operating system files. These export files store information about schema objects, for example, tables and stored procedures. Import is a utility that reads export files and restores the corresponding data into an existing database.

Although import and export are designed for moving oracle data, you can also use them as a supplement method of protecting data in an oracle database. You should not use import and export as the sole method of backing up your data.

• WHOLE DATABASE AND PARTIAL DATABASE BACKUPS:

* Whole database backups
* Table space backups
* Data file backups
* Control file backups

Whole Database Backups:

A ‘Whole Database Backup’ includes backups of the control file along with all data files. Whole database backups are the most common type of backup.

Whole database backups do not require you to operate the database in a specific archiving mode. Before performing whole database backups, however, be aware of the implications of backing up in ARCHIVELOG and NOARCHIVELOG modes.

A whole database backup is either a ‘consistent backup’ or an ‘inconsistent backup.Whether or not a backup is consistent determines whether you need to apply redo logs after restoring the backup.You can make backups of the entire database with the following methods:

An operating system utility that makes a separate copy of each individual data file in the database as well as the current control file.

* The RMAN BACKUP DATABASE command
* The RMAN COPY DATAFILE command run against each data file in the database, and the COPY CURRENT CONTROLFILE command run against the control file.

Tablespace Backups:

A tablespace backup is a backup of the data files that constitute the tablespace. For example, if tablespace users contains data files 2,3, and 4, then a backup of tablespace users backs up these three data files.

Tablespace backups, whether online or offline, are valid only I f the database is operating in ARCHIVELOG mode. The reason is that redo is required to make  the restored tablespace consistent with the other tablespaces in the database.

The only time a tablespace backup is valid for a database in NOARCHIVELOG mode is when the tablespace is currently read-only or offline-normal. These cases are exceptions because no redo is required to recover them.

For example, take the scenario depicted

1. You take a tablespace offline normal at some time during day t
2. You make a backup of the tablespace at day t+5.
3. You restore the tablespace at day t+10 with the backup made at day t+5.
4. You make the tablespace read/write at day t+15.

Because there were no changes to the offline tablespaces between t+5 and t+10, no media recovery is needed. If you make the tablespace read/write at t+15 and then subsequently attempt to restore the t+5 backup, however, oracle requires media recovery for the changes after t+15. Hence, you can only open the database if all necessary redo is located in the online redo logs.

You can make backups of an individual tablespace with the following methods:

An operating system utility that makes a separate copy of each data file in the tablespace

The RMAN BACKUP TABLESPACE command syntax

Data file backups:

A data file backup is a backup of a single data file. Data file backups, which are not as common as table_ space backups, are valid in ARCHIVELOG databases.

The only time a data file backup is valid for a database in NOARCHIVELOG mode is if:

* Every data file in a tablespace is backed up. You cannot restore the database unless all data files are backed up.

* The datafiles are read-only or offline-normal.

You can make backups of an individual data-file using these methods:

* An operating system utility
* The RMAN BACKUP DATAFILE command
* The RMAN COPY DATAFILE command which produces a ‘data-file copy’.

Control file backups:

Backing up the control file is crucial aspect of backup and recovery.Without an accessible control file, you cannot mount or open the database.

If you use RMAN as your backup and recovery solution, and if you run the CONFIGURE CONTROLFILE AUTOBACKUP command, then RMAN automatically backs up the control file whenever you run backup and copy jobs. This backup is called a ‘control file autobackup’. Because the autobackup uses a default file-name. RMAN can restore this backup even if the RMAN repository is unavailable. Hence this feature is extremely useful in a disaster recovery scenario.

You can make mutual backups of the control file by using the following methods:

The RMAN BACKUP CURRENT CONTROLFILE creates an RMAN-specific backup of the control file, and the COPY CURRENT CONTROLFILE command creates an image copy of the control file.

The SQL statement ALTER DATABASE BACKUP CONTROLFILE makes a binary backup of the control file.

The SQL statement ALTER DATABASE BACKUP CONTROLFILE TO TRACE exports the control file contents to a SQL script file. You can use the script to create a new control file.

Trace file backups have one major disadvantage:

1) they contain no records of archived redo logs, offline ranges for data files, and RMAN backups and copies. For this reason, binary backups are preferable.

Archived Redo log backups:

Archived redo logs are essential for recovering an inconsistent backup. The only way to recover an inconsistent backup without archived logs is to use RMAN incremental backups. To be able to recover a backup through the most recent log, every log generated between these two points must be available. In other words, you cannot recover from log 100 to log 200 if log 173 is missing. If log 173 is missing, then you must halt recovery at log 172 and open the database with the RESETLOGS option. Because archived redo logs are essential to recovery, you should back them up regularly. If you use a media manager, then back them up regularly to tape.

You can make backups of archived logs by using the following methods:

* An operating system utility

* The RMAN BACKUP ARCHIVELOG command

* The RMAN BACKUP….PLUS ARCHIVELOG command

* The RMAN COPY ARCHIVELOG command

• CONSISTENT AND INCONSISTENT BACKUPS

A consistent backup of a database or part of a database is a backup in which all read/write data-files and control files are check-pointed with respect to the same ‘system change number (SCN). Oracle determines whether a restored backup is consistent by checking the data-file headers against the data-file header information contained in the control-file.

The only way to make a consistent whole database backup is to shut down the database with the NORMAL, IMMEDIATE, or TRANSACTIONAL options and make the backup while the database is closed. If a database is not shutdown cleanly, for example, and instance fails or you issue a SHUTDOWN ABORT statement, then the databases’s data-files are always inconsistent—unless the database is a ‘read-only database’ . Instance recovery will be required at open time.

Oracle makes the control files and data-files consistent to the same SCN during a database ‘checkpoint’. The only table-spaces in a consistent backup that are allowed to have older SCNs are read-only and offline normal table-spaces, which are still consistent with the other data-files in the backup because no changes have been made to them.

The important point is that you can open the database after restoring a consistent whole database backup ‘without applying redo’ because the data is already consistent: no action is required to make the data in the restored data-files correct. Hence, you can restore a year-old consistent backup of your database without performing media recovery and without oracle performing instance recovery.

A consistent whole database backup is the only valid backup option for databases operating in NOARCHIVELOG mode, because otherwise redo will need to be applied to create consistency. In NOARCHIVELOG mode, oracle does not archive the redo logs, and so the required redo logs may not exist on disk.

Inconsistent backup:

An inconsistent backup is a backup in which all read/write data-files and control-files have not been check-pointed with respect to the same SCN. For example, one read/write data-file header may contain an SCN of 100 while other read/write data-file headers contain an SCN of 95 or 90. Oracle cannot openthe database until all of these header SCNs are consistent, that is, until all changes recorded in the online redo logs have been applied to the data-files on disk.

If the database must be up and running 24 hours a day, 7 days a week, then you have no choice but to perform inconsistent backups of a whole database. For example, a backup of an offline table-space in an open database is inconsistent with other table-spaces because portions of the database are being modified and written to disk while the backup of the table-space is progressing. The data-file headers for the online and offline data-files may contain inconsistent SCNs. You must run your database in ARCHIVELOG mode to make online backups of online data-files.

If you run the database in ARCHIVELOG mode, then you can construct a whole database backup using backups of online data-files-taken at different times. For example, if your database contains seven table-spaces, and if you backup the control-files as well as different table-space each night, then in a week you will backup all tables-spaces in the database as well as the control-file. You can consider this staggered backup as a whole database backup.

Inconsistent Closed Backups:

You have the option of making inconsistent closed backups if a database is backed up after a system crash or SHUTDOWN ABORT. This type of backup is valid if the database is running in ARCHIVELOG mode, because both online and archived redo logs are available to make the backup consistent.

Caution: Oracle strongly recommends that you do not make inconsistent, closed database backups in NOARCHIVELOG mode.

If you run the database in NOARCHIVELOG mode, then only back it up when you have closed it cleanly with the IMMEDIATE, NORMAL, or TRANSACTIONAL options. Inconsistent whole database backups of databases running in NOARCHIVELOG mode are usable only if the redo logs containing the changes made prior to the backup are available when you restore it-an unlikely occurrence.

The reason that NOARCHIVELOG inconsistent backups are not recommended is that the data-file headers of the backed up files contain different SCNs (a normal shutdown guarantees the consistency of these SCNs), and because the database is in NOARCHIVELOG mode, no archived redo logs are available to apply the lost changes. For this reason, RMAN does not allow you to back up a database that has been running in NOARCHIVELOG mode and shutdown abnormally because the backup is not usable for recovery.

The basic guideline is: if you run your database in NOARCHIVELOG mode, always have a backup that is usable without performing any recovery. This aim is defeated if you need to apply redo from logs to recover a backup.

Archiving un-archived redo log files:

After an ‘online backup’ or inconsistent ‘closed backup’, always ensure that you have the redo necessary to recover the backup by archiving the un-archived redo logs. When the database is open, run the following SQL statement to force oracle to switch out of the current log and archive it as well as all other un-archived logs:

ALTER SYSTEM ARCHIVE LOG CURRENT;

When the database is mounted, open, or closed, you can run the following SQL statement to force oracle to archive all non-current redo logs.

ALTER SYSTEM ARCHIVE LOG ALL;

When the database is mounted, open, or closed, you can run the following SQL statement to archive a specific group, where ‘integer’ is the number of the group:

ALTER SYSTEM ARCHIVE LOG GROUP integer;

Backing up the Archived Logs and the control file:

After open or inconsistent closed backups, oracle recommends backing up all archived logs produced during the backup, and then backing up the control file after the backup, then you cannot recover the backup because you do not have all the redo records necessary to make it consistent. Having a control-file backup generated after the completion of the database backup is helpful when using RMAN because the control file contains a record of the backup.

Creating and Running PL/SQL

As is true for SQL, PL/SQL programs can be invoked from a variety of other languages. Unlike SQL, PL/SQL can actually run in two different places:

* Inside the Oracle database server, as stored code. If you call PL/SQL from SQL*Plus, Java, or any other language, this is typically where it’s going to run.
* In one of Oracle’s application environments such as Oracle Forms or Oracle Reports, as a program that executes on a client computer. Often, the runtime environment lives on a middle tier, operated across the network from a browser-only or “thin” client.

SQL*Plus

The granddaddy of Oracle front ends, Oracle’s SQL*Plus provides a command-line interpreter for both SQL and PL/SQL. That is, it accepts statements from the user, sends them off to the Oracle server, and displays the results.

Often maligned for its primitive user interface, SQL*Plus is one of my favorite Oracle tools. I actually like the lack of fancy gizmos and complicated menus. Ironically, when I started using Oracle (circa 1986), this product’s predecessor was boldly named UFIUser Friendly Interface. Two decades later, even the latest version of SQL*Plus is still unlikely to win any user friendliness awards, but at least it doesn’t crash very often.

Today, Oracle supports three different styles of executing SQL*Plus:

As a console program

This is a program that runs from a shell or command prompt[*] (an environment that is sometimes called a console).[*] Oracle calls this the “command-line interface” version of SQL*Plus, but I find that somewhat confusing, because two of the three styles provide a command-line interface.

As a pseudo-GUI program

This form of SQL*Plus is available only on Microsoft Windows. I call it a “pseudo-GUI” because it looks pretty much like the console program but with bitmapped fonts; few other features distinguish it from the console program. Beware: Oracle has been threatening to desupport this product for years, and it hasn’t really been updated since Oracle8i Database.

Via iSQL*Plus (in Oracle9i Database or later)

This program executes from a web browser connected to a middle-tier machine running Oracle’s HTTP server and iSQL*Plus server.

Performing Essential PL/SQL Tasks
Let’s turn to the highlights of creating , running, deleting, and otherwise managing PL/SQL programs, using SQL*Plus as the front end. Don’t expect to be overwhelmed with detail here; treat this section as a glimpse of topics that will be covered in much greater detail in the chapters ahead.
Creating a Stored Program
To build a new stored PL/SQL program, you use one of SQL’s CREATE statements. For example, if you want to create a stored function that counts words in a string, you can do so using a CREATE FUNCTION statement :
CREATE FUNCTION wordcount (str IN VARCHAR2)
RETURN PLS_INTEGER
AS
declare local variables here
BEGIN
implement algorithm here
END;
/
As with the simple BEGIN-END blocks shown earlier, running this statement from SQL*Plus requires a trailing slash on a line by itself.
Assuming that the Oracle DBA has granted you Oracle’s CREATE PROCEDURE privilege (which also gives you the privilege of creating functions), this statement causes Oracle to compile and store this stored function in your schema; if your code compiles, you’ll probably see a success message such as:
Function created.
If a table or stored program named wordcount already exists in your Oracle schema, CREATE FUNCTION will fail with the error message ORA-00955: name is already used by an existing object. That is one reason that Oracle provides the OR REPLACE option, which you will want to use probably 99% of the time.
CREATE OR REPLACE FUNCTION wordcount (str IN VARCHAR2)
RETURN PLS_INTEGER
AS
same as before
The OR REPLACE option avoids the side effects of dropping and recreating the program; in other words, it preserves any object privileges you have granted to other users or roles. Fortunately, it replaces only objects of the same type, and it won’t automatically drop a table named wordcount just because you decided to create a function by that name.
As with anonymous blocks used more than once, programmers generally store these statements in files in the operating system. I could create a file wordcount.fun for this function and use the SQL*Plus @ command to run it:
SQL> @wordcount.fun

Function created.

As mentioned earlier, SQL*Plus does not, by default, echo the contents of scripts. You can SET ECHO ON to see the source code scroll past the screen, including the line numbers that Oracle assigns; this setting can be helpful when troubleshooting. Let’s introduce an error into the program by commenting out a variable declaration.
SQL> /* File on web by Chares Menezes: wordcount.fun */
SQL> SET ECHO ON
SQL> @wordcount.fun
SQL> CREATE OR REPLACE FUNCTION wordcount (str IN VARCHAR2)
2     RETURN PLS_INTEGER
3  AS
4  /* words PLS_INTEGER := 0;  ***Commented out for intentional error*** */
5     len PLS_INTEGER := NVL(LENGTH(str),0);
6     inside_a_word BOOLEAN;
7  BEGIN
8     FOR i IN 1..len + 1
9     LOOP
10        IF ASCII(SUBSTR(str, i, 1)) < 33 OR i > len
11        THEN
12           IF inside_a_word
13           THEN
14              words := words + 1;
15              inside_a_word := FALSE;
16           END IF;
17        ELSE
18           inside_a_word := TRUE;
19        END IF;
20     END LOOP;
21     RETURN words;
22  END;
23  /

Warning: Function created with compilation errors.

SQL>
This message tells us that the function was created, but that there were compilation errors that render it inoperable. We’ve succeeded in storing the source code in the database; now we need to tease the details of the error out of the database. The quickest way to see the full text of the error message is to use SQL*Plus’ SHOW ERRORS command, abbreviated as SHOW ERR:
SQL> SHOW ERR
Errors for FUNCTION WORDCOUNT:

LINE/COL ERROR
——– ———————————————-
14/13    PLS-00201: identifier ‘WORDS’ must be declared
14/13    PL/SQL: Statement ignored
21/4     PL/SQL: Statement ignored
21/11    PLS-00201: identifier ‘WORDS’ must be declared

The compiler has detected both occurrences of the variable, reporting the exact line and column numbers. To see more detail about any server-based error, you can look it up by its identifierPLS-00201 in this casein Oracle’s Database Error Messages document.
Behind the scenes, SHOW ERRORS is really just querying Oracle’s USER_ERRORS view in the data dictionary. You can query that view yourself, but you generally don’t need to

Show Other Errors
Many Oracle programmers know only one form of the SQL*Plus command:
SQL> SHOW ERRORS
and they incorrectly believe that they must query the USER_ERRORS view directly to see anything but the error messages from the most recent compile. However, you can append to SHOW ERRORS an object category and a name, and it will display the latest errors for any object:
SQL> SHOW ERRORS category [schema. ]object
For example, to view the latest errors for the wordcount function, specify:
SQL> SHOW ERRORS FUNCTION wordcount
Use caution when interpreting the output:
No errors.
This message actually means one of three things: (1) the object did compile successfully; (2) you gave it the wrong category (for example, function instead of procedure); or (3) no object by that name exists.
The complete list of categories this command recognizes varies by version, but includes the following:
DIMENSION
FUNCTION
JAVA SOURCE
JAVA CLASS
PACKAGE
PACKAGE BODY
PROCEDURE
TRIGGER
TYPE
TYPE BODY
VIEW

It’s common practice to append a SHOW ERRORS command after every scripted CREATE statement that builds a stored PL/SQL program. So, a “good practices” template for building stored programs in SQL*Plus might begin with this form:
CREATE OR REPLACE program-type
AS
your code
END;
/

SHOW ERRORS
When your program contains an error that the compiler can detect, CREATE will still cause Oracle to store the program in the database, though in an invalid state. If, however, you mistype part of the CREATE syntax, Oracle won’t be able to figure out what you are trying to do and won’t store the code in the database.
Executing a Stored Program
For example, you can invoke a function such as wordcount in any location where you could use an integer expression. Here is a short illustration of how I might test the wordcount function with a strange input (CHR(9) is an ASCII “tab” character 
BEGIN
DBMS_OUTPUT.PUT_LINE(‘There are ‘ || wordcount(CHR(9)) || ‘ words in a tab’);
END;
/
I have embedded wordcount as part of an expression and supplied it as an argument to DBMS_OUTPUT.PUT_LINE. Here, PL/SQL automatically casts the integer to a string so it can concatenate it with two other literal expressions; the result is:
There are 0 words in a tab
Showing Stored Programs
Sooner or later you will want to get a list of the stored programs you own, and you may also need to view the most recent version of program source that Oracle has saved in its data dictionary. This is one task that you will find far easier if you use some kind of GUI-based navigation assistant (SqlDeveloper) but if you lack such a tool, it’s not too hard to write a few SQL statements that will pull the desired information out of the data dictionary.
For example, to see a complete list of your programs (and tables, indexes, etc.), query the USER_OBJECTS view, as in:
SELECT * FROM USER_OBJECTS;
This view shows name, type, creation time, latest compile times, status (valid or invalid), and other useful information.
If all you need is the summary of a PL/SQL program’s callable interface in SQL*Plus, the easiest command to use is DESCRIBE:
SQL> DESCRIBE wordcount
FUNCTION wordcount RETURNS BINARY_INTEGER
Argument Name                  Type                    In/Out Default?
—————————— ———————– —— ——–
STR                            VARCHAR2                IN
DESCRIBE also works on tables, views, object types, procedures, and packages. To see the complete source code of your stored programs, query USER_SOURCE or TRIGGER_SOURCE.

Dropping a Stored Program
If you really, truly don’t need a particular stored program any more, you can drop it using SQL’s DROP statement :
DROP FUNCTION wordcount;
You can drop a package, which can be composed of up two elements (a specification and body), in its entirety:
DROP PACKAGE pkgname;
Or you can drop only the body without invalidating the corresponding specification:
DROP PACKAGE BODY pkgname;
Any time you drop a program that other programs call, the callers will be marked invalid.

Blowin' In The Wind – Joan Baez

Kevin Rudolf – Let It Rock (Junior)

(Feat. Lil’ Wayne)

I see your dirty face

Hide behind your collar

What is done in vain

Truth is hard to swallow

So you pray to God

To justify the way you live a lie, live a lie, live a lie

And you take your time

And you do your crime

Well you made your bed

I’m in mine

(Chorus)

Because when I arrive

I bring the fire

Make you come alive

I can take you higher

What is this, forgot?

I must now remind you

Let It Rock

Let It Rock

Let It Rock

Now the son’s disgraced

He, who knew his father

When he cursed his name

Turned, and chased the dollar

But it broke his heart

So he stuck his middle finger

To the world

To the world

To the world

And you take your time

And you stand in line

Well you’ll get what’s yours

I got mine

Chorus:

Because when I arrive

I bring the fire

Make you come alive

I can take you higher

What is this, forgot?

I must now remind you

Let It Rock

Let It Rock

Let It Rock

Yeeeeeaaaaah!

Wayne’s world

Planet Rock

Panties drop

And the top

And she gonna rock ’til the camera stops

And I sing about angels like angela

(Rock)

And Pamela

(Rock)

And Samantha

(Rock)

And Tamara

And Amanda

?-*******

Im in here up like betch what’s up

Mechanic, me, I can fix you up

I can lick you up

I can lick you down

Shorty we can go wherever just pick a town

And the jewelry is louder than an an engine sound

Big as rocks like on the ground

Dirty like socks that’s on the ground

Chorus:

Because when I arrive

I bring the fire

Make you come alive

I can take you higher

What is this, forgot?

I must now remind you

Let It Rock

Let It Rock

Let It Rock

Let It Rock

Let It Rock

Let It Rock

Just Let It Rock

Let It Rock

Let It Rock

Let It Rock

Let It Rock

Let It Rock

Let It Rock

I’m back like I forgot somethin’

I’m somethin

Rulin’ rock rubbin’ rap runnin’

Miles like I’m trying to get a flat stomach

Like Wayne the personal trainer

My aim is perfect I’ll bng ya

Period, Like the remainda

(Bridge: Kevin Rudolph)

I wish I could be

As cool as you

And I wish I could say

The things you do

But I can’t and I won’t live a lie

No not this time

Bigfile Tablespaces in Oracle

Starting with Oracle 10g, tablespaces can be created with the BIGFILE option, which specifies that the tablespace will consist of only a single datafile, which can be up to 8 exabytes (8 million terabytes) in size. Thus using a single large file can drastically simplify storage management in large databases.

But , Obviously, these extremely large files are only suitable for use on disk arrays. Generally, bigfile tablespaces must be locally managed and must use ASSM.

Note: Both undo tablespaces and temporary tablespaces can be created as bigfile tablespaces even though they can’t be configured with ASSM.

All normal tablespace CREATE and ALTER operations work with bigfile tablespaces, with the obvious exception of adding a datafile. Since they must consist only of a single datafile, attempting to add another file to a bigfile tablespace will result in an error. When specifying file or file extension sizes for bigfiles, you can specify sizes in gigabytes or terabytes by using the “G” and “T” abbreviations, respectively. For example:

CREATE BIGFILE TABLESPACE big_tbs
DATAFILE SIZE 2T AUTOEXTEND ON NEXT 500G MAXSIZE 200T
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 50G
SEGMENT SPACE MANAGEMENT AUTO;

At database create time, you can indicate that the database should default to creating bigfile tablespaces rather than normal (smallfile) ones. To do this, include the SET DEFAULT BIGFILE TABLESPACE clause in the CREATE DATABASE statement as follows:

CREATE DATABASE bigdb
SET DEFAULT BIGFILE TABLESPACE
UNDO TABLESPACE undotbs
DEFAULT TEMPORARY TABLESPACE temp01;

If you set bigfile tablespaces as the default at database creation time, you can still create smallfile tablespaces by simply using the CREATE SMALLFILE TABLESPACE command.

You can also, at database create time, designate the undo and/or temporary tablespaces as bigfile tablespaces by adding the BIGFILE qualifier to the appropriate phrase of the CREATE DATABASE command; for instance:

CREATE DATABASE bigdb2
BIGFILE UNDO TABLESPACE undotbs DATAFILE SIZE 5G
BIGFILE DEFAULT TEMPORARY TABLESPACE temp01 TEMPFILE SIZE 500M;

Yellow Dog Updater Modified (YUM)

Yellow Dog Updater Modified (YUM) in 2007 we created a repository and also configured access to repositories in RHEL5. In YUM – I’ll configure YUM by using its main configuration file, yum.conf, which resides in ‘/etc’ in LINUX.

For any yum newbie’s like ME. , a quick definition and a look at history. YUM is a package manager (an installer and remover) for RPM systems. It is tailor made to update groups of machines without having to update each specific RPM. The software locates and obtains the correct RPM packages from repositories, freeing you from having to manually find and install new applications and/or updates. The beauty of YUM is in its simplicity to use. You can use a single command to update all system software with backward compatibility of RPM taken care of .. .

Some tips :

yum list “*ssh*”                 # lists packages that have “ssh” in the name
chkconfig yum on            # make yum update all programs every night
yum remove up2date    # remove a program, dependencies handled
yum -y install radius       # -y answers “yes” to all questions

Sao Joao in Goa

Come Goa and in June/July, The Sao Joao celebrations, and the youth will be ready for the joyous cry of ’Viva San Joao’ and a big splash of water. The youth will take their dives in the wells, rivers , ponds of their villages, wearing a crown of leaves and flowers. This is said to be symbolic of the time in the Holy Bible when Elizabeth was favored with the visit of her cousin Virgin Mary, The mother of Jesus Christ, during her pregnancy and when, it is said, the unborn John jumped for joy in her womb.

Viva Sao joao

Luckily for those going to celebrating the feast of St. John (Joao in Konkani), the rains have so far been smiling, with the wells mostly full after the long wait for the monsoon this year, To enjoy the event, one has to be in the villages of Goa, where the fun lies. It is not only the men that jump into the wells but also the women . They come in a colorful procession, bringing with them fruit and the inevitable bottle of ’feni’. It is known that friendships have been built during the festival, leading to couples finding for themselves life partners.(Some say so )

Even thought we happen to say that the Tourist season is over ,we all see new faces in the vicinity especially all jumping into the open water pools. I guess this is the very essence of the slogan “365 days on a holiday “.

Linked to the festival is the ’sangodd’, where canoes, with colorful buntings, sail the rivers with participants joining in song and dance. They also wear different kinds of costumes, significant of those ancient biblical times, and in most cases, stand to win handsome prizes for the best and original costume.

Needless to say, this festival is the harbinger of the harvest season to follow, where farmers will be seen busy ploughing their fields and hoping for the rains to be kind to them, and help in the good yield for this year.

Viva Sao joao

Viva Sao joao

Goa In India.. Some Info..

Goa is India’s smallest state in terms of area and the fourth smallest in terms of population. Located on the west coast of India in the region known as the Konkan, it is bounded by the state of Maharashtra to the north, and by Karnataka to the east and south, while the Arabian Sea forms its western coast.

Panaji is the state’s capital. Vasco da Gama is the largest city. The historic city of Margao still exhibits the influence of Portuguese culture. The Portuguese first landed in Goa as merchants, in the early 16th century, and conquered it soon thereafter. The Portuguese overseas territory existed for about 450 years, until it was annexed by India in 1961.

Renowned for its beaches, places of worship and world heritage architecture, Goa is visited by hundreds of thousands of international and domestic tourists each year. It also has rich flora and fauna, owing to its location on the Western Ghats range, which is classified as a biodiversity hotspot.

Geography and climate

Goa encompasses an area of 3,702 km² (1,430 sq mile). It lies between the latitudes 14°53’54″ N and 15°40’00″ N and longitudes 73°40’33″ E and 74°20’13″ E. Most of Goa is a part of the coastal country known as the Konkan, which is an escarpment rising up to the Western Ghats range of mountains, which separate it from the Deccan Plateau. The highest point is the Sonsogor, with an altitude of 1,167 meters (3,827 feet). Goa has a coastline of 101 km (63 miles).

Goa’s main rivers are the Mandovi, the Zuari, the Terekhol, Chapora River and the Sal. The Mormugao harbor on the mouth of the river Zuari is one of the best natural harbors in South Asia. The Zuari and the Mandovi are the lifelines of Goa, with their tributaries draining 69% of its geographic area. Goa has more than forty estuarine, eight marine and about ninety riverine islands. The total navigable length of Goa’s rivers is 253 km (157 miles). Goa has more than three hundred ancient tanks built during the rule of the Kadamba dynasty and over a hundred medicinal springs.

Most of Goa’s soil cover is made up of laterites which are rich in ferric aluminium oxides and reddish in color. Further inland and along the river banks, the soil is mostly alluvial and loamy. The soil is rich in minerals and humus, thus conducive to plantation. Some of the oldest rocks in the Indian subcontinent are found in Goa between Molem and Anmod on Goa’s border with Karnataka. The rocks are classified as Trondjemeitic Gneiss estimated to be 3,600 million years old, dated by the Rubidium isotope dating method. A specimen of the rock is exhibited in the Goa University.

Goa, being in the tropical zone and near the Arabian Sea, has a hot and humid climate for most of the year. The month of May is the hottest, seeing day temperatures of over 35 °C (95 °F) coupled with high humidity. The monsoon rains arrive by early June and provide a much needed respite from the heat. Most of Goa’s annual rainfall is received through the monsoons which last till late September.

Goa has a short winter season between mid-December and February. These months are marked by nights of around 20 °C (68 °F) and days of around 29 °C (84 °F) with moderate amounts of humidity. Further inland, due to altitudinal gradation, the nights are a few degrees cooler. During March 2008 Goa was lashed with heavy rain and strong winds. This was the first time in 29 years that Goa had seen rain during March.

Tourism

Tourism is generally focused on the coastal areas of Goa, with decreased tourist activity inland. In 2004 there were more than 2 million tourists reported to have visited Goa, 400,000 of which were from abroad.

Goa has two main tourist seasons: winter and summer. In the winter time, tourists from abroad (mainly Europe) come to Goa to enjoy the splendid climate. In the summertime (which, in Goa, is the rainy season), tourists from across India come to spend the holidays.

This tiny state is situated on the west coast of India, between the borders of Maharastra and Karnataka and is better known to the world as the former Portuguese enclave on Indian soil. With the rule of the Portuguese for over 450 years and the consequential influence of the Latin culture, Goa presents a somewhat different picture to the foreign visitor than any other part of the country. The state of Goa is famous for its excellent beaches, churches, and temples. The Bom Jesus cathedral is another famous attraction in Goa. The Fort Aguada too is a major tourist attraction. Recently a Wax Museum on Indian history, culture and heritage has also opened in Old Goa.

Beaches

The one reason to visit Goa is, its beaches. About 125 KM of the coast line is dotted with beaches. These beaches are divided into North Goa and South Goa Beaches. The further north or south you go, the more isolated the beaches get. However, if you’re looking for people, then visit some of the more popular beaches like Baga and Anjuna. These beaches are lined with shacks that provide fresh sea food and drinks. Some shacks arrange special events to attract more customers.

Historic sites and neighbourhoods

Goa has two World Heritage Sites: the Bom Jesus Basilica [25] and a few designated convents. The Basilica holds the mortal remains of St. Francis Xavier, regarded by many Catholics as the patron saint of Goa (the patron of the Archdiocese of Goa is actually the Blessed Joseph Vaz). Once every twelve years, the body is taken down for veneration and for public viewing. The last such event was conducted in 2004. The Velhas Conquistas regions are also known for its Goa-Portuguese style architecture. There are many forts in Goa such as Tiracol, Chapora, Corjuem, Aguada, Gaspar Dias and Cabo de Rama.

In many parts of Goa, mansions constructed in the Indo-Portuguese style architecture still stand, though in some villages, most of them are in a dilapidated condition. Fontainhas in Panaji has been declared a cultural quarter, showcasing the life, architecture and culture of Goa. Some influences from the Portuguese era are visible in some of Goa’s temples, notably the Mangueshi Temple, although after 1961, many of these were demolished and reconstructed in the indigenous Indian style.

In Christ Alone

12 Days of Christmas

Quotes..

“You’re not crazy, you’re going sane in a crazy world!”

“Flying is simple. You just throw yourself at the ground and miss.” ~Douglas Adams, So Long, and Thanks for the Fish

I used to be sane, but I got better.

I have a grip on reality–just not this particular one.

We’re all in this alone.

Think you’re confused? Wait until I explain it.

Mad: Affected with a high degree of intellectual independence.

Honesty is the best policy, but insanity is a better defense.

Some mornings it’s just not worth gnawing through the straps.

I made a mental note and now I can’t remember where I put it!

I think, therefore I am dangerous.

“I have a firm grip on reality. Now I can strangle it.”

Sometimes the facts fail to correspond to known reality.

He can’t be insane, I’ve never seen him at the meetings…

I came, I saw, I had no idea what was going on, I left.

All things considered, insanity may be the only reasonable alternative.

Don’t let your mind wander, it’s too little to be let out by itself.

Of all the things I’ve lost, I miss my mind the most.

I met some crazy people. They made me their leader…

I tried to contain myself, but I escaped.

Didn’t I meet you in some other hallucination??.

Never question authority. It doesn’t know either.

Some of my best personalities are crazy!

El toro loco: the crazy lawnmower.

Today has been one hell of a week.

One man’s insanity is another man’s vision.

I live in a world of my own, but you’re welcome to visit.

Fun is taking you to the edge of insanity, then pushing.

Being normal isn’t one of my strengths

My next nervous breakdown is dedicated to you.

Life is a Highway …..and I feel like Roadkill!

The irony of life is that no one gets out alive…

5 out of 4 people are schizophrenic

I think. I think I am. Therefore I am… I think.

I feel happy! I feel happy! I feel ha..

I’m not afraid of death! What’s it going to do? Kill me?

Quick, pick a color from 1 to 10.

“Researchers have discovered that chocolate produces some of the same reactions in the brain as marijuana…. The researchers also discovered other similarities between the two, but can’t remember what they are.”

“I stopped believing in Santa Claus when my mother took me to see him in a department store, and he asked for my autograph.” -Shirley Temple

“Today you can go to a gas station and find the cash register open and the toilets locked. They must think toilet paper is worth more than money.” -Joey Bishop

Red meat is NOT bad for you. Now, blue-green meat, that’s REALLY BAD for you.

You spend your whole life believing that you’re on the right track, only to discover that you’re on the wrong train.

“Man invented language to satisfy his deep need to complain.” -Lily Tomlin

“Too bad the only people who know how to run the country are busy driving cabs and cutting hair.”

“On the one hand, we’ll never experience childbirth. On the other hand, we can open all our own jars.”
-Bruce Willis (On the difference between men and women)

“There are only two reasons to sit in the back row of an airplane. Either you have diarrhea, or you’re eager to meet people who do.”

“The more I study religions the more I am convinced that man never worshipped anything but himself.”

“I know Kung Fu, Karate, and 47 other dangerous words.”

“Any girl can be glamorous. All you have to do is stand still and look stupid.”

“Behind every successful man is a surprised woman.” -Maryon Pearson

“I never married because there was no need. I have three pets at home which answer the same purpose as a husband. I have a dog which growls every morning, a parrot which swears all afternoon and a cat that comes home late at night.” -Marie Corelli

“You been drinking the cough syrup again?” -Michael Cohen (The Forbidden Game Trilogy by L.J. Smith)

“Wasn’t it Satre who said hell was eternity spent in a room with your friends?” -Michael Cohen

“This isn’t much of a game. No reset. It’s win, lose, or die,” -Michael Cohen

“Reality, has teeth and claws. And sicne that’s true, wouldn’t you rather be one of the hunters than one of the hunted?” -Julian (Forbidden Game Trilogy)

“You and your damned, damned fruitcakes!!” -Jenny Thorton (Forbidden game Trilogy)

“Dagaz.” Rune of change. “Thurisaz.” The horn.”Gebo.” For Sacrifice.”Isa.” Primal ice. “Kenzaz.” Primal Fire.”Raidho.” Traveling. “Uruz.” For piercing the veil between worlds. -Jenny Thorton (FGT)

“Nothing really dies as long as it’s not forgotten.” -Julian (FGT)

“How many times must I say it? You are my familiar, not the head of my guild! You are bound to my service and you will do as I say.” -Morgana Shee

“Fight them with what?! Jujitsu? Tae Kwon Do? The force?” -Janie Hodges-Bradley

“What do they do with the people who do run from them?”
“Run them till they drop. The stories don’t agree about what happens if they catch you. I only know that sorcerei get out of the way fast if they hear the Fava-Se-Ra. That’s the opening bars of the hunting call.” -Alys & Janie

Ever notice that ‘What the hell’ is always the right decision? -Marilyn Monroe

he broke my heart, so i broke his jaw

Mystify people with your intelligence, and if u cant do that, mystify them with your B.S.

Did it hurt when I fell from heaven? No, but it hurt when they clipped my wings for being the devil.

Ociffer, I swear to drunk Im not God!!!!!!

Ur jealous cause the voices are in my head

~*Everyone keeps telling me that the right guy will come along…I think mine got hit by a bus.*~

Shoot For The Moon
We say we love flowers..
yet we pluck them.
We say we love trees..
yet we cut them down.
And people still wonder why
some are afraid..
When told they are loved.  -Unknown

“No matter where you go, there you are.”

“Sometimes you get shown the light in the strangest of places if you look at it right.”

“We are what we pretend to be, but we better be very careful what we pretend.”

Children aren’t happy without something to ignore, And that’s what parents were created for.

Imagination is more important than intelligence.

No bird soars too high if he soars with his own wings.

It is just Me, or are Myself and I crazy too?

“Love is a temporary form of insanity”

Is that it, Dad? Did the penguin tell you to do it?” -Billy Madison

“To define your own value for your blog is to declare independence from parent companies like Google that thrive by assigning value as they see it.”

“Unless you try and do something beyond what you have mastered, you will never grow.” -C.R. Lawton

“Show me a sane man and I will cure him for you.” -Carl Gustav Jung

“Don’t cry because it’s over. Smile because it happened.” -Dr. Suess

“Love is a temporary form of insanity”

“One man’s insanity is another man’s vision.”

“Keep away from people who try to belittle your ambition. Small people always do that, but the really great make you feel that you, too, can become great.” -Mark Twain

“He who asks a question is a fool for a minute; he who does not remains a fool forever.” -Chinese Proverb

“Don’t worry about what people think about you–the chances are they seldom think about you at all.”

“Calm and happiness is not something that evolves or happens to you, it’s a practice. Whether it’s Yoga, or sex, or writing a blog post, or playing guitar.”

“There is a thin line between genius and insanity. I have erased this line.” -Oscar Levant

“Most, if not all, problems brought to therapists are issues of love. It makes sense that the cure is also love.” -Thomas Moore

“Sometimes we reach the boiling point before we realize that the stove is on. Become aware of your feelings – keep your eye on the stove.” -Karen Dougherty

“Words are the physicians of a mind diseased.” -Aeschylus

“when you accept everything for what it is without labels you are outside of your ego.” – Eckhart Tolle, “A New Earth”

“Work as if you don’t need the money, love as if you’ve never been hurt, dance as if no one’s watching.”

“Life is a short, warm moment and death is a long cold rest. You get your chance to try in the twinkling of an eye: Eighty years, with luck, or even less.” -Pink Floyd

“It doesn’t matter how inspired your work is if you’re not healthy.”

“A guitar in my house, accessible, is a semi-automatic weapon against the blues.”

“Take it easy or take it hard but TAKE IT!” – Woody Guthrie

“There is a very fine line between ‘hobby’ and ‘mental illness’”

“You should not confuse your career with your life.”

“A closed mouth gathers no foot.”

“Never miss a good chance to shutup.”

“Up to a certain point every man is what he thinks he is.” – F. H. Bradley

“The important thing is not to stop questioning.” – Albert Einstein

“The best thing you can do behind a person’s back?… is give them a pat.”

“Failure is an event, never a person.” – William D. Brown

“The measure of a man is the way he bears up under misfortune.” – Plutarch

“Love your enemies, for they tell you your faults.” – Benjamin Franklin

“I hate a song that makes you think that you are not any good. I hate a song that makes you think that you are just born to lose. Bound to lose. No good to nobody. No good for nothing. Because you are too old or too young or too fat or too slim too ugly or too this or too that.” – Woody Guthrie

“I used to rule the world
Seas would rise when I gave the word
Now in the morning I sleep alone
Sweep the streets I used to own.”
Coldplay (Viva la Vida)

Care deeply..give freely…think kindly…act gently and be at peace with the world.

Even if your blog does manage to bring you and other people a lot of money, ultimately it is only the standards that you set for yourself that should determine your success. – Michelle Stein, Blog Author of “It Might be Love”

“How to become a Greek scholar: Enroll in Greek 1. The same is true of learning blogging and the internet. No shortcut exists.”

“You can make more friends in two months by becoming interested in other people than you can in two years by trying to get other people interested in you.” – Dale Carnegie

“We are all time travelers moving at the speed of exactly 60 minutes per hour.” – Spider Robinson

“Never be ashamed to make goals that are glaringly simple. You’ll be far better off than most who don’t set goals at all.”

“The greatest tragedy in life is not death; the greatest tragedy takes place when our talents and capabilities are underutilized and allowed to rust while we are living.”

“If at first you don’t succeed, redefine success.”

“Our lives are co-authored in dialogue.”

“Joy is not in things; it is in us.” – Benjamin Franklin

“May you have warmth in your igloo, oil in your lamp, and peace in your heart!” – Eskimo proverb

“Quality questions create a quality life. Successful people ask better questions, and as a result, they get better answers.” – Anthony Robbins

“Learn how to find peace between the things that happen.” – Susan Riley

Speeding…. No one thinks Big of you..

Hey All ..  Please drive Safe …

IMPDP / EXPDP Data pumps in Oracle 11g

Oracle Data Pump is a new and unique feature of Oracle Database 11g. A new public interface package, DBMS_DATAPUMP, provides a server-side infrastructure for fast data and metadata movement between Oracle databases. It is ideal for large databases and data warehousing environments, where high-performance data movement offers significant time savings to database administrators.

Data Pump automatically manages multiple, parallel streams of unload and load for maximum throughput. The degree of parallelism can be adjusted on-the-fly. There are new and easy-to-use Export and Import utilities (expdp and impdp), as well as a web-based Enterprise Manager export/import interface. Because of this, dump files, log files, and sql files are accessed relative to the server-based directory paths. Data Pump requires that directory objects mapped a file system directory be specified in the invocation of the data pump import or export.

Configuration  (Windows/Unix)

No much work here, just execute the following 2 statement and you are done, what are we doing here is just creating a directory object for the data dumps to be dumped to since this is a server side application we definitely required a server location to put the dumps, also the user doing the dumps must have the DBA role or EXP_FULL_DATABASE Role . (During my  implememtation i did not have to grant role EXP_FULL_DATABASE the DBA role seem to be sufficient and working )

–
– Create a directory object name for implementing EXPDP/IMPDP
–
Create directory expdp_dir as  ‘C:\app\Oracle\backupdp’;

Create directory expdp_dir as  ‘ /u01/backup/exports’ ;      (Unix )

Grant read,write on directory expdp_dir to system,charles,user1,user2;

Using EXPDP :

Actually doing a EXPDP dump look below..

–Database Export Mode  (Example)
expdp system/manager DIRECTORY=expdp_dir DUMPFILE=expfull_DB.dmp FULL=y LOGFILE=expfull_DB.log

–Schema Export Mode (Example)
expdp charles/charles DIRECTORY=expdp_dir DUMPFILE=charles_exp.dmp SCHEMAS=scott,scott_history LOGFILE=charles_imp.log

C:\>expdp charles/charles DIRECTORY=expdp_dir DUMPFILE=charles_exp.dmp SCHEMAS=c
harles LOGFILE=charles_imp.log

;;;
Export: Release 11.1.0.6.0 – Production on Thursday, 02 July, 2009 18:19:59

Copyright (c) 2003, 2007, Oracle.  All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting “CHARLES”.”SYS_EXPORT_SCHEMA_01″:  charles/******** DIRECTORY=expdp_dir DUMPFILE=charles_exp.dmp SCHEMAS=charles LOGFILE=charles_imp.log
Estimate in progress using BLOCKS method…
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCACT_SCHEMA
. . exported “CHARLES”.”DNN_DYNAMICFORMS_WIZARD”         7.937 KB       1 rows
. . exported “CHARLES”.”DNN_DYNAMICFORMS_BLACKLIST”          0 KB       0 rows
. . exported “CHARLES”.”DNN_DYNAMICFORMS_DYNEVTPAYS”         0 KB       0 rows
. . exported “CHARLES”.”DNN_DYNAMICFORMS_DYNQSTEVENT”        0 KB       0 rows
. . exported “CHARLES”.”DNN_DYNAMICFORMS_EVENTS”             0 KB       0 rows
. . exported “CHARLES”.”DNN_DYNAMICFORMS_FLOCALTION”         0 KB       0 rows
. . exported “CHARLES”.”DNN_DYNAMICFORMS_QLOCALTION”         0 KB       0 rows
. . exported “CHARLES”.”DNN_DYNAMICFORMS_QUESTEVTHF”         0 KB       0 rows
. . exported “CHARLES”.”DNN_DYNAMICFORMS_QUESTION”           0 KB       0 rows
. . exported “CHARLES”.”DNN_DYNAMICFORMS_QUESTIONOPT”        0 KB       0 rows
. . exported “CHARLES”.”DNN_DYNAMICFORMS_QUESTIONROLE”       0 KB       0 rows
. . exported “CHARLES”.”DNN_DYNAMICFORMS_QUESTIONRSP”        0 KB       0 rows
Master table “CHARLES”.”SYS_EXPORT_SCHEMA_01″ successfully loaded/unloaded
******************************************************************************
Dump file set for CHARLES.SYS_EXPORT_SCHEMA_01 is:
C:\APP\ORACLE\BACKUPDP\CHARLES_EXP.DMP
Job “CHARLES”.”SYS_EXPORT_SCHEMA_01″ successfully completed at 18:20:51

Using  IMPDP :

Doing a IMPDP dump look below..

–Database Export Mode (Example)
impdp system/manager DIRECTORY=expdp_dir DUMPFILE=expfull_DB.dmp FULL=y LOGFILE=impfull_DB.log

–Schema Export Mode (Examples)
impdp charles/charles DIRECTORY=expdp_dir DUMPFILE=expfull.dmp SCHEMAS=hr,scott,scott_history LOGFILE=schema_imp.log

impdp charles/charles DIRECTORY=expdp_dir DUMPFILE=charles_exp.dmp
SCHEMAS=scott LOGFILE=charles_imp.log

;;;
Import: Release 11.1.0.6.0 – Production on Thursday, 02 July, 2009 18:27:49

Copyright (c) 2003, 2007, Oracle.  All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table “CHARLES”.”SYS_IMPORT_SCHEMA_01″ successfully loaded/unloaded
Starting “CHARLES”.”SYS_IMPORT_SCHEMA_01″:  charles/******** DIRECTORY=expdp_dir DUMPFILE=charles_exp.dmp SCHEMAS=charles LOGFILE=charles_imp.log
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported “CHARLES”.”DNN_DYNAMICFORMS_WIZARD”         7.937 KB       1 rows
. . imported “CHARLES”.”DNN_DYNAMICFORMS_BLACKLIST”          0 KB       0 rows
. . imported “CHARLES”.”DNN_DYNAMICFORMS_DYNEVTPAYS”         0 KB       0 rows
. . imported “CHARLES”.”DNN_DYNAMICFORMS_DYNQSTEVENT”        0 KB       0 rows
. . imported “CHARLES”.”DNN_DYNAMICFORMS_EVENTS”             0 KB       0 rows
. . imported “CHARLES”.”DNN_DYNAMICFORMS_FLOCALTION”         0 KB       0 rows
. . imported “CHARLES”.”DNN_DYNAMICFORMS_QLOCALTION”         0 KB       0 rows
. . imported “CHARLES”.”DNN_DYNAMICFORMS_QUESTEVTHF”         0 KB       0 rows
. . imported “CHARLES”.”DNN_DYNAMICFORMS_QUESTION”           0 KB       0 rows
. . imported “CHARLES”.”DNN_DYNAMICFORMS_QUESTIONOPT”        0 KB       0 rows
. . imported “CHARLES”.”DNN_DYNAMICFORMS_QUESTIONROLE”       0 KB       0 rows
. . imported “CHARLES”.”DNN_DYNAMICFORMS_QUESTIONRSP”        0 KB       0 rows
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCACT_SCHEMA
Job “CHARLES”.”SYS_IMPORT_SCHEMA_01″ completed with 3 error(s) at 18:28:09