How can I replicate an Oracle 11g database(data+structure) on my local machine for development?

There are a number of ways to move the data over.

There are a number of ways to move the data over: Restore an RMAN backup on your test server Export and import the data using exp/expdp/imp/impdp Export and import using a transportable tablespace (Further Info) Use database links to duplicate the data using SQL.

I always like the "Restore from RMAN backup" option. It's a great way to ensure that your know how to...restore a backup. You know, in case you have to do that one day.

– Adam Hawkes Apr 8 '10 at 15:36.

You can use the Database Configuration Assistant to generate a template from your production database. This will give you all the parameters and tablespaces, among other things. You will need to tweak the configuration somewhat; for instance the file paths may be wrong, and some parameters may need downsizing.

You can then feed that template into DBCA to clone the database on you Linux machine. To get the schemas and data you should use Data Pump (rather than the older Import / Export utlities). This can be run off the command line or from PL/SQL.

Bear in mind that using production data in a development or test environment can cause you to run foul of data protection laws and other compliance issues. It depends on what your application does and what jurisdiction you operate under. But if your production system contains citizens' personal data you need to be very careful.

There are products out there which will apply masking as part of a data import process (Oracle sells one) but they tend to be expensive. Rolling your own masking product can be tricky: if this applies to your situation be sure to get your compliance staff (legal team) involved early.

I would suggest you install Oracle XE which is free to use on your local if your development is not something that is related to core database features. You can then use the methods given above to pump data into Oracle XE and compile your code on it, though for development I don't think you would need data as much as that in production.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.