Moving a table between databases

If you have access to both Databases then u really don't have to export/import. You need to have a Database link.

Here is the steps (not syntex):

- connect to dbA
- Create a Database link to dbB (
- Create  table tab_dbA as select * from tab_dbB@dbB;

Brams

When I try this command i get unkown command or file name errors, if I run it in sqlplus I get errors as well


As for linking the two databases, this is not an option

Brams, I agree with you. I know it is the simplest way to do it . But as Merith was saying, he/she is new to db, I don't want him/her to break his/her head at this moment.

cheers..
jagannadh

Merith,

what errors you are getting. Pls post the errors here. You have to run the above commands from either $ prompt or c:\> prompt and not from sqlplus.

I think the easest way for new users is exp/imp that Jagannadh suggested.

Can you give me more detail on exp/imp.. I am on a nt 4.0 box with oracle 8.0.5.0

Microsoft(R) Windows NT(TM)
(C) Copyright 1985-1996 Microsoft Corp.

C:\>exp map_results_dba/(removed) file=emp.dmp log=emp.log indexes=y rows=y tables=
map_results
The name specified is not recognized as an
internal or external command, operable program or batch file.

C:\>

I think that Jagannadh has given your the steps. Since you are using 8.0.5 on NT, the exp/imp actually are exp80/imp80.

You can import the table into different user account (schema in Oracle) in the second database.

GT

The command you used is correct. Try to find the exp*.exe in your NT box. Similarly check for imp*.exe.

You can go to c:\orant\bin or d:\orant\bin and look for exp*.exe and imp*.exe.

I do not remember exactly , but the export executable will be:

exp.exe or exp30.exe or exp80.exe.

So check up and let us know.

good luck..

Testing it now.. will let you know in a few minutes

Well, it worked.. Thank you very much..

I did get two small problems though that I would like to note,

1. I had to specify full=y
2. I got errors becouse it copies the grant permissions and I didn't have the users created that were to be granted rights.. But no biggy there..

Again thank you very much

Good to know that your probelm is solved.

1)If you specify FULL=Y, it will export the entire database
2) You can ignore such errors, 'caz they are caused as the other granted users were not there in your second database.