Hot answers tagged oracle-11g-r2
Have you seen this? https://community.oracle.com/thread/889338?start=0&tstart=0 It states you can only exchange partitions from a partitioned table to a non-partitioned table, or vice-versa. You'd need to temporarily exchange the partition into an interim, non-partitioned, table, then into the target partitioned table.
This is really a Unix/Linux question, but it does relate to Oracle, so I'll give an answer. In Unix, the system makes great use of what it calls "spawning" (or "giving birth"). When you run a command, a new process is created which takes all of its information from the parent. Essentially, it's a copy of the parent - it's a new bash shell, which then sets ...
The session(s) using the temporary table can be queried as: select sid from v$lock where type = 'TO' and id1 = (select object_id from dba_objects where object_name = '&temp_table_name'); Then you can kill these sessions or have them release the locks gracefully.
You should not install more than one Oracle Client (per architecture) on one machine. For sure they do not work in parallel. By heart I know several issues: You would have to change PATH settings in order to determine which Client you want to use. TNS_ADMIN environment variable is used by both versions and must be set accordingly. Oracle OleDB provider ...
Only top voted, non community-wiki answers of a minimum length are eligible