Retrieve records from another database

Hi,
Please help me for retrieving data from a table in a database to the same table located in another database, not on the same server, different users and passwords.
I need suggests about the SQL Statement, or if somebody can help me how to do this using Toad, it will be O.K.
Thanks in advance,
Richard

select * from RemoteUser.RemoteTableName@RemoteDatabaseLink

ask your DBA to create a remote database link.

(or)

refer the syntax for creating remote database link.

thanks