Hi, I am having a problem:
ORA-09817: Write to audit file failed.
Linux Error: 28: No space left on device
ORA-09945: Unable to initialize the audit trail file
Linux Error: 28: No space ...
Hi Team,
I have a question regarding indexes.
Why do we required to drop index on prodcution database and recreate it again. I have seen somany times, guys are talking about droping in...
ORA-19815 :WARNING :DB_RECOVERY_FILE_DEST_SIZE OF 2147483648 BYTES IS 100% USED AND HAS 0 REMAINING BYTES AVAILABLE.
ABOVE MESSAGE COME WHILE I TAKE HOT BACKUP.
PLS DO WRITE ME THE SOLUTI...
I recently asked a question between PHP, ColdFusion, PERL, ASP, JSP, etc.
http://www.experts-exchange.com/Web/Web_Languages/Q_21145097.html
I'm wondering the same in terms of databases. ...
Does anyone have a license key for Allfusion Erwin Data Modeler 7r?
Hello,
i try to use the DIRECTORY feature with the commands listed above in order to execution
first i create a phisical directory c:\tmp
and file names.txt with the next information:
1,...
I need to open a .wdb file. It's a Microsoft Works database. But I don't have MS Works. I do have Access and Excel. How do I do this?
I have a database that sends an automatic email. Everything worked fine but I had to create a new database and reload the tables. I lost one reference that I had to select again in VB in doi...
I have a cache database that we can only access through ODBC (no mumps). I have a SQL database, db01, which is storing data related to a table in one of the cache databases. I setup a linked s...
my database 'generaltestportal' get (suspect)
I ran sp_resetstatus 'generaltestportal'
in sqlserver 2000 query analyzer
but it show the following message
Prior to updating sysdatabases e...
how do i set my archive log dest to USE_DB_RECOVERY_FILE_DEST currently it is set as follows
SQL> archive log list;
Database log mode Archive Mode
Automatic archival ...
I am a newbie to MS SQL, I have a table with 3000 records, I add a new colume called "ContactId", and want to assign values to this colume starting from 1 to 3000. any idea would be very much ...
Hi All........
One of our programmers needs to write a Business Objects version 6.5.1 report against a Paradox 7 database (both on Windows Server 2003). Please could someone suggest a suit...
Hi,
I got a Sybase dump file(I guess so, all the information tables and data in this file. I do not know the version). I am trying to load it into a database on Sybase 11.5 for NT. By the s...
Hi ,
I had wirte a code to connect remote oracle server but i cant connect its says ORA-12514 error can u tell what is that error and how to slove that !!
Error Is
java.sql.SQLExce...
Is ity possible to stop and start a MS SQL 2000 Job from the Windows command line or in a batch file ?
Thanks,
Chris.
I have a database in mysql for room availability in a hotel. I want to allow a search for room type and date availability.
I use the between function of sql but the problem is searching for m...
I've created a simple test table with the sql statement:
create table player (PID char(15), Name char(15), Clan char(15), PRIMARY KEY (PID) );
How can I change the primary key from PID ...
Can anyone explain me what we mean by phrase Delta Load in an ETL environment
I just started a consulting assignment as an Oracle DBA, and to my dismay, I am hearing rumors that client is seriously considering dumping Oracle for DB2. I would welcome any objective observ...
I am trying to learn Visual Web Developer -- Express Edition. I have SQL Server 2005 (not Express) installed on my machine. When I open the ASP.Net Web Site Administration Tool and go into t...
I am trying to import a comma delimited file (.CSV) into our SQL Server 2005 Database. I am trying to use BULK INSERT. The CSV file is a FEDEX report. It has fields such as "Mon, May 1, 2008"....
Hello Experts,
My Oracle skills are rusty and need help in refreshing Oracle plsql programming concepts.
How can I prompt a user during a pl/sql procedure execution, get value for a v...
Hello experts
I am using Oracle9i.
Need SQL statement to get number or rows affected by previous Select/Insert/Update/Delete query.
Thx.
I used the follow string connections:
strConnect = "Driver={SQL Server}; Persist Security Info=False; Server=SERVER NAME; Database=DB NAME; Trusted_Connection=Yes;"
AND
strConnect = "Drive...
