All geek questions in one place

Oracle SQL Developer copy database step by step

I have big problems copying an Oracle database to the same server, but with a different name that needs to be used as a development database.

I'm used to SQL Server, I'm new to Oracle (11g).

I wanted to use a "copy of the database" from SQL Developer, but I get errors all the time. At first it was about the missing table spaces. Then, when I manually created them in my new empty DB, the errors concerned missing users. I wanted to create users manually, but first I needed to create the missing roles. When all this was done, it did not receive the missing indexes ...

How to copy everything I need using a “copy database”?

Any advice is appreciated!

+3
source share
3 answers

SQL Developer copy copies objects only between schemas. Do you want to just make a copy of the circuit? Or a whole new database, including all schemas?

Judging by your question, I assume the latter. If so, RMAN "database duplication" can help you.

See http://www.oracle-base.com/articles/11g/duplicate-database-using-rman-11gr2.php in the great Tim Hall website.

+2
source

The best way for you is to create a new user:

Starting MSDOS Shell Connect to your database using the system administrator Sqlplus / as sysdba account

:

user2 user2password;

2 ;

GRANT CONNECT TO user2;

GRANT DBA TO user2;

exit oracle prompt

MSDOS Shell 1 :

exp user1/password

exp user1/password @connectString

, tnsnames.ora , , user1

2 :

imp user2/password2 fromuser = user1 touser = user2

, ( CmdShell, )

+1

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

More articles:


All Articles