Search results for query: *

If the current path that SQL*Plus checks, as a default, to resolve scripts (as in "@<script>") is path "/x/y/z", what change can I make, for my SQL*Plus session only, to use as my new default path, "/a/b/c"?

When I run "top" in *nix, there are about a dozen processes that are running between 80%-100% CPU utilization on an 8-CPU box. They are all processes logged in as Oracle. Customers are starting to complain. We are not presently running Oracle Enterprise Manager. What queries can I run (as a...

This is the second time in as many weeks that I have encountered problems with database-link references within a PL/SQL block, while the problem does not exist at the SQL prompt. Note, below, the successful DESCRIBE of the "submissions" table via the database link, "mss":SQL> desc...

Here are facts about my situation. 1) I am logged into Oracle 10g as the SYSTEM user. 2) SYSTEM user is (as usual) a member of the DBA role, which I have confirmed possesses the CREATE ANY TABLE privilege. I attempt to issue this command:CREATE TABLE SYS.X (Y NUMBER); * ERROR at Line 1...

You MAI-ers did a remarkable job helping MiniMufasa name her business (thread1256-1128199 ; Winner: KenCunningham's "Proof Positive Inventory" entry, with great honorable mentions from many other MAI-ers). I, too, am eager to benefit from your individual and collective creativity in the naming...

Since Oracle re-designed their MetaLink website, I can't find what I need. Can someone please give me either the navigation route or the URL on metalink.oracle.com to confirm the following: Latest Enterprise Edition database release version (e.g. 9.2.0.5) for a given o/s (e.g. Solaris 64-bit)...

I need some advice for using an enhanced "CONNECT BY...START WITH" statement. (I know that Oracle MVP, "Sem" posted an excellent solution many months ago, but Tek-Tips's SEARCH feature is woefully inadequate to find his solution...I've unsuccessfully searched by every key word I can think of.)...

I don't want to bring up Brand X (Oracle), but what query can I issue in Sybase that will yield similar results to this Oracle query: SQL> select file_name, bytes,maxbytes 2 from dba_data_files 3 order by file_name; FILE_NAME...

I am on a Windows2000 server. I am running Oracle 8.1.7. My ORACLE_HOME and ORACLE_SID system variables are properly set. I have checked my Windows "Users & Groups" settings and my login ("Administrator") is a member of the ORA_DBA group. Given all of this, when I run "svrmgrl" and "connect...

I have a SQL Server7 instance and databases. Following my backing up the databases, can someone please confirm the steps I should follow to complete an "in-place" upgrade of the SQL Server7 instance to SQL Server2000? Thanks.

Could you please advise me: 1) What CLP SQL command can I issue to confirm the case-sensitivity of my SQL Server database and 2) What steps must I go through to "flip" the case sensitivity a SQL Server database without compromising data integrity? Thanks.

When I attempt to connect to my MySQL instance, I have been receiving the error: "ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)" I checked and there is no "mysql.sock" file in the directory "/var/lib/mysql" where it should be. How can I...

Can you please advise me how to move everything MySQL from C: to D:? I'll need help with commands to move the software and the data files. I appreciate any help you can give me. Becca

As an example of my situation, for one of my databases, I have a "...Data.MDF" file that is 982MB; my "...Log.LDF" file for that database is 5GB. As similar scenario exists with other databases, as well. Can someone confirm for me the CLP command syntax I should use to reduce the storage...

My problem: I have specified to SQL Server in the installation's Maintenance plan to remove database-backup files that are older than 24 hours. (This directive works fine on two of my four SQL Server installations.) On two of the servers, SQL Server never deletes files as I have requested. I...

I do not have an available PC to test this, so can someone tell me definitively (i.e., no guessing on this one) whether the Oracle client install results in "exp"/"imp" utility availability? Thanks, Becca

We have successfully used "mysqldump" to create backup files for our databases on our mysql installation. We wish to test the quality/integrity of our dump files by importing a dump file into an empty database having a name different from the original source database from which we created the...

First, does MySQL architecture support the creation of multiple MySQL server installations on one machine? (Specifically, I am hoping for two different MySQL 4.0.12 servers on the same machine for two different departments with two different DBAs.) If so, what naming convention (and...

Gurus, I have been doing maintenance on serveral database instances, getting rid of unwanted tablespaces (and rm'ing the tablespace datafiles). I thought that I had already done a "DROP TABLESPACE..." on an empty tablespace, so I did an "rm <datafile>". I then discovered that I had not yet...

We have successfully replaced our old version of DB2 server with DB2 version 8.2, running on Solaris. Everything runs like a champ. We want to upgrade a Windows client with the appropriate DB2 client software to access the Solaris DB2 V8.2 server. What specific downloadable client software...