I'm sorry it may sound stupid but I've been wondering about how multiple databases are automated before the virtualization era. Can a DB Adminsitrator make a stored procedure to get data from a remote RDBMS and select them into a local table?
Sure, in SQL Server at least you can set up a linked server to other SQL Servers, Oracle, MySQL etc. and pull data from them. There are other approaches as well (such as OPENQUERY). An example would be:
SELECT * INTO dbo.localtable FROM OtherServer.database.dbo.TableName;
In Oracle I think the equivalent is database link but I confess that I have never used it.
In Oracle, you can use a database link object to do it.
CREATE TABLE localtable as (SELECT * FROM remote_table@link_name)