Copy tables from one Oracle instance to another?
628203Mar 12 2008 — edited Mar 13 2008Sorry for a dumb newbie question, but I have done some homework trying to find an answer for myself and can't. I'm a Finance guy pretending to be an IT guy because IT won't help us get what we want.
I'm creating a little DataMart with about 10 or so tables from our Oracle production system. I have Oracle full database 9i loaded on my pc. I have query/read access only to dev and production databases.
How can I copy table from one Oracle instance to the instance on my PC? I have TOAD and can write beginner level SQL. I can follow instructions. But I can't find a way to go across instances in my SQL.
Also I can't move the whole table at once because table is too large. I only want like the last year or so, but I suppose I can just add a where statement to whatever statement I could use to copy the table.
Please help, thanks.