New answers tagged oracle-10g
0
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 ...
2
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 ...
2
Yes, it will -- of course if it persistently refuses to you might have to kill the processes, and face instance recovery on restart.
2
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.
0
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
