I'm trying to import a tablespace from one server to another (both Oracle 8i servers). The problem is that once the import is performed, the tables in the new tablespace are owned by the original user not the user I used in the touser clause. ( Original user/tablespace name exists on both servers. ) I dropped the Original User on the second server and that wound up clearing a number of tablespaces.
Server 1 contains:
UserA tablespace owned by UserA
At this point, the tables in the UserB tablespace are owned by UserA, not by UserB as I would expect. We dropped the UserA tablespace and User and that wound up clearing a number of other tablespaces including UserB.
What I would like to do is to be able to copy data from one tablespace to another but have them completely independent. (i.e. Be able to drop User A without affecting any other tablespaces.)
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
How to Create User-Defined Aggregates in Oracle
Before we begin creating these things, what are user-defined aggregates? They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines