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

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

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 tablespace_name)a,

(select '! cp '||file_name||' /backup_dir'oscmd,tablespace_name from ...

>> full