I created database in oracle 11g this database name are "test". and then i created new user in test database. i connect to created new user and password and then create table, procedure and triggers in SQL Developer. i will backup this test database and restore in another pc. please help me step by step how to backup and restore.
3
-
Actually a simple google search would have given the answer you requiredBalanivash– Balanivash2012-09-14 06:48:08 +00:00Commented Sep 14, 2012 at 6:48
-
4Actually a simple Google search gives this page as a result, Google does not store the answers to questions, websites like StackOverflow do!Patrick McDonald– Patrick McDonald2014-08-22 09:11:11 +00:00Commented Aug 22, 2014 at 9:11
-
Actually a simple google search did only return pretty complicated results, videos and how to do it from Windows, Gnome or KDE.Michael Niemand– Michael Niemand2015-06-02 15:08:25 +00:00Commented Jun 2, 2015 at 15:08
Add a comment
|
1 Answer
To transfer your user(schema) with all related objects(table, triggers and so on) to another computer with Oracle 11g installed on, you can do the following:
On a first computer (where you have your user created) use exp command line utility to unload user's(schema's) data to an OS file(dump file).
exp userid=yourusername/youruserpassword@Connect_Identifier File=OSPath
Example
Exp userid=scott/tiger@ORCL file=c:\scott.dmp
transfer created *.dmp file to another computer with Oracle 11 installed on and use imp command line utility to load *.dmp file into a NEW (it means you have to create a user id it doesn't exist already ) created schema(users)
imp userid/password@Connect_identifier fromuser=user_name_you_have_data_unloaded_from touser=new_user_name file=Path_to_*.dmp file
As you are using Oracle 11g you can use Data pump Export and Data Pump Import utilities to do the same thing. Exp and Imp are there for backward compatibility but the will work as expected.
