58266

Oracle SQL Developer copy database step by step

Question:

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...

<strong>How do I copy everything I need with 'Database copy'?</strong>

Any advice is greatly appreciated!

Answer1:

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, <em>including all schemas</em>?

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

See <a href="http://www.oracle-base.com/articles/11g/duplicate-database-using-rman-11gr2.php" rel="nofollow">http://www.oracle-base.com/articles/11g/duplicate-database-using-rman-11gr2.php</a> at Tim Hall's excellent site.

Answer2:

<blockquote>

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

Launch MSDOS Shell Connect to your database using system manager account sqlplus / as sysdba

Then write these sequences:

CREATE USER user2 IDENTIFIED BY user2password;

GRANT ALL PRIVILEGE TO user2 WITH ADMIN OPTION;

GRANT CONNECT TO user2;

GRANT DBA TO user2;

exit oracle prompt

In MSDOS Shell again, export your current user1 like this :

exp user1/password

or exp user1/password@connectString

if you have a connection string specified in tnsnames.ora Answer all the questions by default, give a name to your export file, and specify that you want to export only the user user1

Then proceed to the importation of the dump in your new user2 like this :

imp user2/password2 fromuser=user1 touser=user2

Answer all the questions by default, give the name to your export file (if you don't change the default folder of CmdShell you will not have to specify the complete folder)

</blockquote>

Answer3:

An interesting link on this from Oracle documentation:

<a href="http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmdupdb.htm#BRADV010" rel="nofollow">http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmdupdb.htm#BRADV010</a>

Recommend

  • Refetch events when switching fullcalendar views
  • Best practice for condensing code? [closed]
  • Ignoring unknown parameters: point.colour.1
  • How to pass method result as parameter to base class constructor in C++?
  • Nested projects in multiproject visual studio templates
  • Running jasmine tests for a component with NgZone dependency
  • Double dispatch in Java example
  • conditions for accessors in Coldfusion ORM
  • How to resolve permission denied maybe missing internet permission?
  • Retaining data after updating application
  • Django return user model id with L
  • Examples of how to a STS in .Net 4.5 using WCF
  • In Java, how can I construct a File from a resource?
  • Using MouseListener to select a range of cells in a grid
  • In matplotlib, how do you change the fontsize of a single figure?
  • WPF Template Binding in ToggleButton UserControl
  • How to explicitly/implicitly implemented interface members in C++/CLI?
  • Do query loads all the data in memory
  • Spring: No transaction manager has been configured
  • Tomcat memory Leak
  • accepts_nested_attributes_for practical form use for in Rails 3
  • PLSQL: Get number of records updated vs inserted when a merge statement is used
  • Object and struct member access and address offset calculation
  • OOP Javascript - Is “get property” method necessary?
  • Date Conversion from yyyy-mm-dd to dd-mm-yyyy
  • Debug.DrawLine not showing in the GameView
  • Android - Material Design - NavigationView - How to put vertical scroll?
  • ActiveRecord query for a count of new users by day
  • Cancel a live stream “fast motion” catch-up in Flash
  • does jqgrid support a multiple checkbox list for editing
  • CSS Linear-gradient formatting issue accross different browsers
  • Optimizing database types to compact database (SQLite)
  • Cross-Platform Protobuf Serialization
  • In LanguageTool, how do you create a dictionary and use it for spell checking?
  • Do I've to free mysql result after storing it?
  • bootstrap to use multiple ng-app
  • How to get icons for entities from eclipse?
  • Turn off referential integrity in Derby? is it possible?
  • JaxB to read class hierarchy
  • Python/Django TangoWithDjango Models and Databases