Hi all,
How can i disable the user from system?
Thanks
Pat
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Consolidation, virtualization, commoditization and moving to Linux are fast becoming the mantras of forward-thinking CIOs, and Oracle has realized major benefits by adhering to them.
This sto...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Oracle’s new ADR with command interface shows promise as a way for DBAs to quickly investigate diagnostic information.
This story continues at
http://www.dbasupport.com/oracle/ora11g/ADR1.s...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello,
I am trying to create a statement that will return plot numbers that don't exist in every five year period:
1965
1970
1975
1980.. etc until 2005
some of the plots don't ex...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi,
My database version is 9.2.0.8 and it's using raw filesystem.
For the last one week,I'm getting the following error in alert log,
Errors in file /u02/oracle/app/product/orahome/a...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I came to know that while exporting and importing the data into a new database in 10g the table will be reorganized as part of this process. Is this correct? If yes, my question will be
how do...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
When we connect to the databases using Crystal reports or any other non oracle specific tool, there are hundreds of tables named BIN$/uyewyiuoycvds8cyweee9998==$0 or similar
Is there anything th...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I am installing oracle 10g2 version on Red Hat Enterprise Linux AS release 4 (kernal 2.6.9-78.EL) and getting following errros.. please sugges as i am in middle of installation
Error in invoki...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi, I want to exclude user from database auditing.
- Audit Session; - will audit all user sessions
- now I Want to exclude DBSNMP user from auditing
is it possible ?
Thanks
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi,
I have restarted our DB server and now I cannot seem to start one of the database's. When logging on via sqlplus I get the message: "Connected to an idle instance."
When running "Start...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Oracle VM Templates offer a time-saving approach to deploying a fully configured software stack by providing pre-installed and pre-configured images of enterprise software.
This story continu...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi all,
how can i shrink the space used by tablespaces, I have some table reaching to 99% used and want to shrink it.
how can i make it automated job to shrink if the usage is more than 70...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I am sure there is a simple reason why I am getting errors. I have used GROUP BY statements before and not had this problem. So there must be something small that is wrong with my syntax that I ca...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi all,
We have Oracle 10g database. At present we are using Rollback segments (6 RBS) instead of UNDOTBS. Now we are planning to switch over to UNDOTBS.
I don't know how to switch over ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi, I have to compare two tables in different database.The table contains more than 1 million records and i have to automate this process and one more thing i cannot creat database link..Please pr...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
the database server is restarting daily and how can we check because of any issues with the database... the problem is occuring.
the Os is sun solaris and the database is 9i
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi,
I installed and configured Oracle Database Gateways for ODBC for MySQL.
Everything seems ok.
- When I tried inserting row to MySQL ==> OK :
SQL> insert into "b"@mysql values(to_...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Oracle developers continue their contributions to the Linux kernel.
This story continues at
http://www.dbasupport.com/oracle/new..._support.shtml [http://www.dbasupport.com/oracle/news/kern...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi,
how can i create report which includes user log in and log out information. also fail login as well.
Please guide!! totally new to this!!
Thanks
Pat
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Could someone explain the difference between 'alter session kill ...' vs 'alter session disconnect ...'?
I had a database where connection from the app server exceed process limits. I found t...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hey,
I M stuck with a problem. Here it is as :
I have a table called Temp which has somem columns.Now one column hav differnt value but comma separated.For ex:
Temp Name TempLocation
tes...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi all,
Please any one can send me Oracle 10g RAC Presentation file.
Thanks in advance...
Regards,
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello All,
I need definitions of all tables, views, functions, store procedures etc... of a particular user..
I mean how can i take all tables, view, functions, store procedures creation...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Oracle announces that it has agreed to acquire Global Knowledge Software LLC (GKS), a division of Global Knowledge, Inc.
This story continues at
http://www.dbasupport.com/oracle/news/GKS.s...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Could someone tell me what this statement is doing?
AND CASE WHEN pcl.clec_dspch_type_cd = ''ZZZZZZ''
THEN ''ZZZZZZ''
ELSE DECODE(SUBSTR(pcl.clec_dspch_type_cd, 4, ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Browse sub-categories 
