Oracle SQL Developer copy database step by step

sql database oracle oracle-sqldeveloper database-administration
SonOfGrey picture SonOfGrey · Nov 7, 2012 · Viewed 27.7k times · Source

I'm having big trouble in copying an Oracle DB to the same server but with another name, to use as a development DB.

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

I wanted to use the 'Database copy' from SQL Developer, but I'm getting errors all the way. First it was about missing tablespaces. Then when I manually created them in my new empty DB the errors were about missing users. I wanted to create the users manually, but then I first needed to create missing roles. When all that was done, it failed on missing indexes...

How do I copy everything I need with 'Database copy'?

Any advice is greatly appreciated!

Answer

Colin 't Hart picture Colin 't Hart · Nov 7, 2012

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

Judging by your question, I'm assuming the latter. If so, RMAN "database duplication" may help you.

See http://www.oracle-base.com/articles/11g/duplicate-database-using-rman-11gr2.php at Tim Hall's excellent site.

Related questions

How to enter special characters like "&" in oracle database?

I want to insert special character & in my insert statement. My insert is: INSERT INTO STUDENT(name, class_id) VALUES ('Samantha', 'Java_22 & Oracle_14'); If I try to run this query I am getting a popup and it …

Read More
copy from one database to another using oracle sql developer - connection failed

I am trying to copy a table from one database to another using oracle sql developer. I have the username, password and SIDs. copy from uname1/password1@SID1 to uname2/pwd2@SID2 insert table1 (*) using (select * from message_table); However …

Read More
Execute Statement or Run Script?

While entering a SQL statement in Oracle SQL Developer, I noticed that I have two choices. I can either "Run Statement" or "Run Script". A similar choice seems to be available in SQL Maestro as well, although named "Execute query" …

Read More