пятница, 16 апреля 2010 г.
|
| sadas Guest 03:53:54 |
| | sadas |
| | Add comment |
вторник, 13 апреля 2010 г.
|
Topic awaiting moderation nikejordanaaa 12:00:10 |
суббота, 10 апреля 2010 г.
|
| Hi everyone,I have the same problem mentioned by Odd B... Guest 11:48:25 |
| | Hi everyone,
I have the same problem mentioned by Odd B :
"When I run under system everythings work fine with dbms_metadata.get_ddl.
But under user A I want to see metadata from user B, there is always the error ORA_31603. Cannot find the object in schema B. Even gave user dba roles ... Eample: select dbms_metadata.get_ddl('INDEX','DIM_ACTION_IDX01',B) from dual;
When I run this under B, there is no problem. I am using dbms_metadata.get_ddl in a package, and want different users to use this."
Can anyone help me? Thanks. Pala.
|
| | Add comment |
понедельник, 22 марта 2010 г.
|
| the analysis of selected documents can be performed by... Guest 19:03:44 |
| | the analysis of selected documents can be performed by various data recovery solutions. You may try the fix mdb program: http://www.recoverytoolbox.com/access_fix_error_3021.html for example, it is one of the most efficient tools |
| | Add comment |
|
| the analysis of selected documents can be performed by... Guest 19:00:02 |
| | the analysis of selected documents can be performed by various data recovery solutions. You may try the access file recovery tool: http://www.recoverytoolbox.com/ms_access_file_recovery_service.html for example, it is one of the most efficient tools |
| | Add comment |
воскресенье, 21 марта 2010 г.
|
| get the repair damaged pdf file utility... Guest 16:35:01 |
| | get the repair damaged pdf file utility: http://www.recoverytoolbox.com/pdf.html and start the parsing of affected documents if you’d like to repair not openable files. It does not take a lot of time |
| | Add comment |
|
| get the how to repair damaged pdf files utility... Guest 16:33:50 |
| | get the how to repair damaged pdf files utility: http://www.recoverytoolbox.com/how_to_convert_pdf_corrupted_file_into_uncorrupted_file.html and start the parsing of affected documents if you’d like to repair not openable files. It does not take a lot of time |
| | Add comment |
|
| get the dbf database recovery software tool... Guest 16:19:05 |
| | get the dbf database recovery software tool: http://www.recoverytoolbox.com/data_base_corrupt_file_to_recover_foxpro.html and start the parsing of affected documents if you’d like to repair not openable documents. It does not take a lot of time |
| | Add comment |
пятница, 19 марта 2010 г.
|
| open the link for sql data recovery software download... Guest 13:22:11 |
| | open the link for sql data recovery software download: http://www.recoverytoolbox.com/how_to_recover_corrupted_database_in_ms_sql_server_7.html, if you’d like to get more information about other ways to process corrupted documents |
| | Add comment |
среда, 17 марта 2010 г.
|
| nice tool. However, I have heard about another program for... Guest 18:26:17 |
| | nice tool. However, I have heard about another program for how to ensure queries executed in batch sequence in sql server: http://www.recoverytoolbox.com/sql_server_2000_database_cannot_be_opened.html, check it out and find out why it is more efficient |
| | 3 answer | Add comment |
понедельник, 15 марта 2010 г.
|
| do not hesitate trying various tools for mssql database... Guest 18:32:46 |
| | do not hesitate trying various tools for mssql database repair: http://www.recoverytoolbox.com/mssql_server_repair_database.html, it is often the only choice to retrieve the data from corrupted documents |
| | Add comment |
понедельник, 22 февраля 2010 г.
|
| [root@ultima tmp]# sqlplussqlplus: error while loading... Guest 06:25:32 |
| | [root@ultima tmp]# sqlplus sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory
#yuck!
#this worked for me: #lets find the env script....
[root@ultima tmp]# find / -name *ora*env* -print /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.csh /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oraenv
hmm, oracle_env.sh looks nice
. /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh
[root@ultima tmp]# sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Feb 22 00:25:12 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name:
#sweet! |
| | 1 answer | Add comment |
суббота, 13 февраля 2010 г.
|
| BTW, I often use various data recovery solutions to restore... Guest 18:29:29 |
| | BTW, I often use various data recovery solutions to restore my documents. Please take a closer look at the repair pdf files program: http://www.recoverytoolbox.com/how_to_convert_pdf_corrupted_file_into_uncorrupted_file.html, it fixes corrupted files regardless of the root cause of issue |
| | Add comment |
|
| StephenORA-1113 signalled during: alter database openHas... Guest 18:26:43 |
| | Stephen
ORA-1113 signalled during: alter database open Has nothing to do what so ever with inconsistent datafiles.
What has happened is that the data files are in hot backup mode. from the result of
alter tablespace tb1_name begin backup; cp *.dbf .... etc
So how do you get round this error?
#You should be in mount mode as the database cannot open alter database end backup; alter database open;
Now the fact you have this error means that you have turned on hot backup mode.
When you turn this mode on you have to be in archive log mode. (well in 10g you have to) or you get ORA-01123: cannot start online backup; media recovery not enabled
If this is the case and you have all the archive logs available you can recover and open the database.
Execept of course you will be back to where you were before you copied the files over the good files.
If you use Oracle 10g consider guarantee flashback For putting databases back to where they were before a load
Here is an example
-- First time you do this you db has to be in mount mode
startup mount; create restore point before_load guarantee flashback database; Restore point created.
alter database open;
-- Lets do some work / data load we want to undo later
drop table mytable; Table dropped.
select * from mytable; select * from mytable * ERROR at line 1: ORA-00942: table or view does not exist
-- yep that table is gone
-- Now lets recover it
shutdown immediate; startup mount flashback database to restore point before_load; Flashback complete. alter database open resetlogs;
select * from mytable; COLUMN1 COLUMN2 ---------- ---------- 2 1
-- back to where we were
regards
Stephen George
P.s. Sorry I was two years late |
| | 2 answer | Add comment |
четверг, 11 февраля 2010 г.
|
| along with other ways to keep your data safe, you may also... Guest 18:16:55 |
| | along with other ways to keep your data safe, you may also try the sql server 2000 recovery program: http://www.recoverytoolbox.com/how_to_recover_corrupted_system_database_in_sql_2000.html, the service of data recovery prevents the corruption of specified files |
| | Add comment |
понедельник, 25 января 2010 г.
|
| I think that you may be also interested in another dbf... Guest 12:00:32 |
| | I think that you may be also interested in another dbf repair utility: http://www.recoverytoolbox.com/visual_foxpro_dbf_repair_tools.html, it quickly retrieves affected data from damaged files |
| | Add comment |
четверг, 21 января 2010 г.
среда, 13 января 2010 г.
|
| I had the same error. It looks like it is the result of a... Guest 13:54:06 |
| | I had the same error. It looks like it is the result of a mismatch between your jdbc driver and the dll's supporting it. For instance I had a newer version of ojdbc14.jar (10.2) but my Oracle install was still 10.1.x. To fix I simply copied the older ojdbc14.jar from my ORACLE_HOME\jdbc\lib and used that driver instead of the newest one. |
| | 3 answer | Add comment |
среда, 2 декабря 2009 г.
|
| The guy who posted the last comment is a real {censored}. A... Guest 21:49:46 |
| | The guy who posted the last comment is a real {censored}. A lot has changed since 8i to 10g. The major change is the optimizer mode, which is now cost based and not rule based like 8i. Instead of using rules to tune queries you will need to gather stats for the cost based optimizer. After you gather stats you will need to examine the explain plans and tune based on the plans. Quest SQL optimizer is a really good tool to use. It will suggest different alternative ways to write the query, changing the explain plan. It will also suggest indexes. This will be a good place for you to start tuning. Hope this helps. |
| | 4 answer | Add comment |
понедельник, 30 ноября 2009 г.
|
| /nolog means you aren't logging in. type "conn" to connect... Guest 19:26:53 |
| | /nolog means you aren't logging in. type "conn" to connect first.. |
| | 1 answer | Add comment |
|