New answers tagged oracle-10g
Use the UNPIVOT clause (11g): SQL> SELECT d.*, e.table_column, e.table_data 2 FROM departments d 3 LEFT JOIN (SELECT * 4 FROM (SELECT to_char(employee_id) employee_id, 5 first_name, last_name, to_char(salary) salary, 6 e.department_id 7 ...
Normally it should happen quickly. There could be large transactions that take a while to rollback, or a long running transaction that takes ages to end. If the time is spent for the rollback, you could crash the instance with a good and solid kill -9 on the server procs and use parallel instance recovery. Normally this should not happen but parallel ...
Yes, it will -- of course if it persistently refuses to you might have to kill the processes, and face instance recovery on restart.
Regarding your first error ('dbca: command not found'): ensure ORACLE_HOME is set correctly ensure $ORACLE_HOME/bin is in your path run the command as oracle user If the error persists, check the contents and permissions of $ORACLE_HOME/bin.
This will work, but you have all sorts of problems in your db application. Mainly it seems to me that you haven't structured the tables in a good manner, nor have you normalized the design. You're also quoting column names incorrectly, improperly using selects into variables, etc. If you can, please ask a senior DBA to review your code and db design. create ...
Top 50 recent answers are included