I am using Oracle SQL Developer version 4.0.3. When I open it, I see various TNS entries under Connections.
One of the entries is dev (for testing database). Another entry is ho_live (for live database).
I have developed an APPOINTMENT application whose database can be seen in dev. There is an entry Other Users and it shows a bookcode/tablespace APPOITNMENT. When I expand this node, there is a Tables node where tables are present for APPOINTMENT with data. There is a Views node where Queries are present for APPOINTMENT.
dev is hosted on a separate ip/hostname say 10.123
ho_live is hosted on a separate ip/hostname say 10.456
My requirement is to move the tablespace/bookcode APPOINTMENT (with data) from dev to ho_live.
I am unable to figure out how to do it? Will I have to use the dump file or it may also be accomplished through Oracle SQL Developer? I can access both TNS entries dev and ho_live through SQL Developer.
As far as the version number is concerned, when I run the following query:
SELECT * FROM V$VERSION;
It gives me:
Oracle Database 10g
Regards,
Shehzad