Retrieve records from another database

[rajabalachandra]

select * from RemoteUser.RemoteTableName@RemoteDatabaseLink

ask your DBA to create a remote database link.

(or)

refer the syntax for creating remote database link.