meta user
network profile
| bio | website | google.com |
|---|---|---|
| location | Peak District National Park, United Kingdom | |
| age | 35 | |
| visits | member for | 1 year, 4 months |
| seen | 5 hours ago | |
| stats | profile views | 610 |
Oracle DBA, Unix admin.
Available for employment.
|
Jun 29 |
comment |
ora-07202 when creating standby database Just FYI, the ORA-07202 is signalled when a 0 or NULL string is the result of a parsed parameter (the '' for *.diagnostic_dest in this case. |
|
Jun 29 |
comment |
ora-07202 when creating standby database Try deleting *.diagnostic_dest='' or putting a valid path in |
|
Jun 29 |
comment |
ora-07202 when creating standby database Missing / at the start of the %_file_name_convert string? |
|
Jun 29 |
comment |
How do I set the external editor for PostgreSQL's psql client? I suspect /Users/username/bin/mate is a symbolic link to /usr/local/bin/mate, which doesn't exist. |
|
Jun 29 |
comment |
ora-07202 when creating standby database audit_file_dest is set to a windows path. |
|
Jun 28 |
comment |
Problem in exporting users from oracle database. (Oracle 10g express edition) Is it producing an actual error? I thought the message you quoted was just for information purposes? |
|
Jun 28 |
answered | Disable explicit commits in JDBC, detect them in SQL, or put the database in a readonly state |
|
Jun 28 |
answered | How, if possible, can an .sql file be executed against an oracle database from a bash script |
|
Jun 28 |
comment |
Objects in v$bh but not dba_objects The majority are undo then. Relevant class# are: 7+(n*2) = undo segment n header block. 8+(n*2) = undo segment n block |
|
Jun 27 |
comment |
Can I restore a SQL Server .bak files without SQL Server? Does restoring to something else even make any sense? What do you want to do with the resulting data? |
|
Jun 27 |
comment |
Objects in v$bh but not dba_objects Be nice to see a v$bh.status,count(*) too. I suspect the majority will be free. |
|
Jun 27 |
comment |
Objects in v$bh but not dba_objects What's v$bh.class# for these? Could be undo... |
|
Jun 27 |
comment |
Objects in v$bh but not dba_objects Do they have rows in obj$? |
|
Jun 22 |
comment |
primary key, foreign key relationship between the department and employee tables How do I install? (sql_developer) I WOULD HAVE ANSWERED IN CAPITALS IMMEDIATELY |
|
Jun 18 |
comment |
Oracle - capture row commit order in a table May I ask if you're inserting in multiple threads? That changes the answer somewhat. May I ask what the real scenario is? You have things inserting and things reading - does the order really make a difference, or do you just need to ensure that everything is processed no matter what order? If you need to process in order, you must have multiple processes inserting (otherwise the answer is trivial) & then the insert order is possibly meaningless (unless timestamped) given that the multiple processes won't insert in the same order given any number of re-executions. |
|
Jun 17 |
comment |
Oracle - capture row commit order in a table Judging by your last comment, you don't actually want the order rows were committed in. All you need is a normal sequence. What an odd way to ask the question! |
|
Jun 10 |
comment |
Setting NLS params in logon trigger don't work in oracle 11g All the cool kids use TO_DATE() in their queries. |
|
Jun 8 |
awarded | Constituent |
|
Jun 8 |
awarded | Caucus |
|
Jun 7 |
comment |
Disable explicit commits in JDBC, detect them in SQL, or put the database in a readonly state No, that's not what I meant at all. You create the table in that example at the beginning of the session (with an abstract name) & put the dummy row in. It's there as a wrapper to protect you from a COMMIT. Execute the users code after. |
