All geek questions in one place

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

I work on a test server with Oracle 11g installed. I was wondering if in any case I can replicate a database (environment + data) on my local Linux machine. I am using CentOS 5.3 on Windows XP with SUN Virtual Box. On Windows, I use the sqldeveloper client to connect to the 11g database.

+3
source share
3 answers

There are several ways to move data:

  • Restore RMAN backup on test server
  • Export and import data using exp / expdp / imp / impdp
  • ( )
  • SQL
+2

. , . ; , , . DBCA Linux.

, Data Pump ( Import/Export utlities). PL/SQL.

, . , , . , . , (Oracle ), , , . : , ( ) .

0

I would suggest you install Oracle XE, which can be used on your local computer if your development is not something that is related to the basic functions of the database. Then you can use the above methods to pump data into Oracle XE and compile your code on it, although for development I don’t think you need data the same way as in production.

0
source

Source: https://habr.com/ru/post/1738307/

More articles:


All Articles