Welcome to my blog, I have been looking for a simple easy way to keep my scripts handy, indexed and searchable. By storing them here, I can keep them up-to-date and share them with others as well.
Tell a Friend
Oracle virtual development environment
Software and database development is a demanding, unglamorous career field but is rewarding, albeit a difficult field to get started in. In fact, in order to become a developer, extensive training is needed and you'll need to plot your course and enroll in several computer training classes so that you have the skills needed. The reality of it is that you will likely learn multiple programming languages such as C, C++, Java, .NET,
ADO, Perl, and others throughout your career. Once you have a career started, continuous learning and development of your skills is necessary and often times this means developers will need an environment of servers and software available to them just for this purpose. This is a pricey solution to be sure but there is another easier, less expensive alternative.
A virtual machine (VM) is a software package that executes programs in much the same way a ...>> full
posted by admin March 25, 2012 0:00 | permalink | comments (0) | Development
Using DBMS_CRYPTO to encrypt data
In addition to controlling access to the tables with user grants, you can reduce security risks by encrypting data. Data encryption is not an infallible solution for data security but is an important tool in addressing specific security threats. While getting past the access controls is a rare occurrence, hackers have obtained large lists of credit card numbers after breaking into corporate databases. If the data was encrypted, the stolen information would be useless. Encryption of stored data is thus an important tool in limiting information loss.
Securing sensitive data from users while providing access to the rest of the data can be accomplished with the use of the basic cryptographic functions and procedures available in the DBMS_CRYPTO packages of Oracle 10g and Oracle 11g. You can encrypt/decrypt common Oracle datatypes including RAW and LOBs and it specifically supports BLOBS and CLOBS. There is also globalization support for encrypting data across ...>> full
posted by admin February 01, 2012 0:00 | permalink | comments (1) | Encryption
Quick Hot Backup Generator
Just about everything you need is in the data dictionary, all you
need is to run a query against the DB to create the script. This will
take care of the bulk of the script generation but you should be
careful when running this script and be sure to do your due diligence
regarding ensuring everything is taken care of. You will need to backup
the control, have a list of the files and locations, ensure there are no
datafiles with the same name in different filesystems, ensure there are
no files with spaces or confusing/erroneous errors, etc.
A quick hot backup script to place each tablespace in backup mode, copy the files, take the tablespace out of backup mode....
select distinct a.dbcmd,''||chr(13)||oscmd,''||chr(13)||c.dbcmd from
(select 'alter tablespace '||tablespace_name||' begin
backup;'dbcmd,tablespace_name from dba_tablespaces group by
(select '! cp '||file_name||' /backup_dir'oscmd,tablespace_name from ...>> full
posted by admin January 29, 2012 0:00 | permalink | comments (0) | Backups
Copyright © 2007 - 2012 DataToTheMax.com, LLC. All rights reserved.