my wife always asks what do i do in office. well if she asks me today i would say that I keep doing the same things over and over again. we had an issue with moving data between two oracle databases this morning. At the end of it i still do not know what i did. Ganesh as usual , came to rescue!!. There is simply no tool that would let you move data between two databases. If i hear oracle enterprise manager named as a tool I would just laugh! There was one tool bundled with HsqlDB for data transfer. I am not sure if it takes care of constraints etc or not.
Anyways we did it with oracle import and export tool. Three things to keep in mind when you do it/>- (A) exp user/passwd@TNS , export users, give the dump file some name
- (B) make sure same tablespace exists in the target database
- (C) The target user has the DBA privilege. if not then grant DBA privilege to user.
SQL> connect sys@remotedb as sysdba
Enter password:
Connected.
SQL> grant dba to rajeev;
Grant succeeded.
