dba

Oracle's classic Oracle books: Effective Oracle by-by Thomas Kyte Tom's another classic, in this book, Tom proposed a DBA should not be a fireman, but should be able to prevent problems from the source of the emergence of ... The following

Failure phenomenon: $ sqlplus/as SYSDBA Sp2-1503:unable to initialize Oracle call interface Sp2-0152:oracle May is functioning properly Analysis: Online are said to be timezone and Timezlrg file permissions are not correct, but I do not have

Microsoft's consolidation of SQL Server 2005 and Visual Studio 2005 is not a new initiative, Oracle pioneered the Oracle Developer Tools for Visual Studio 2003 at the end of 2004 Visual Studio. NET is intended to provide. NET platform, integrated

Experimental environment: SOURCE End: ip:192.168.40.10 Database:oracle 11.2.0.1.0 ORCL os:oel5.6 Ogg:fbo_ggs_linux_x86_ora11g_32bit Target side: ip:192.168.40.128 database:10.2.0.1.0 ORCL os:oel5.6 Ogg:fbo_ggs_linux_x86_ora11g_32bit First

The Oracle database provides several different ways to start and close the database, and this article will detail the differences between these startup and shutdown modes and their different capabilities. first, start and close Oracle databases

1. The library name, the table name, the field name must use the lowercase letter, and uses the underline to divide. A) MySQL has configuration parameters lower_case_table_names, not dynamic changes, Linux system defaults to 0, that is, the library

Oracle|unix Oracle 8i for UnixWare 7 is difficult to install. Here is the installation method that I get after n times of failure. is not necessarily the best method, but it is certainly the available method. Software and

TechTarget Reporter was fortunate enough to interview SQL Server consultant and popular blogger, Denny Cherry, in June. He talked about three things that SQL Server DBA needs to know, and describes the trends in SQL Server development. 1, SQL

error| Solve | The problem Today, field personnel reported that Exp was not a sufficient right to report the error. is the user-level exp with the current user, which is supposed to be a problem with no permissions. The test was done according to

See this article today: without the sa password, unable to log in as a Windows integrated identity, what about the DBA? Remembered before the anxious brother asked me a question, a DBA deleted the Windows logged-on user and the SQL Server

1, Application development (application Development) Sql*plus E:\Oracle\Ora81\BIN\SQLPLUSW. Exe 2. Database management (DB administration) DB Configuration Assistant Database Configuration Assistant: Creating, configuring, and deleting Databases

Server bcp utility The bcp utility replicates data in a user-specified format between the Microsoft®sql server™2000 instance and the data file. Grammar BCP {[database_name.] [owner].] {table_name | view_name} | "Query"} {in | out | queryout |

"First, Oracle DBAs working on the x86 platform need to identify what benefits their organizations want to achieve through virtualization technology," said Tony Iams, senior operating system analyst and virtualization expert at Ideas International,

Oracle How to install and run Oracle on your Linux machine start action It can be pretty easy to install Oracle on Redhat, but if you follow Oracle company completely Documentation is not always easy to walk through. The quickest shortcut is Tom

Concise installation and operation instructions for Oracle Oracle 8.05 Oralce Support Linux gave us a free to lift her a good opportunity, but there are many netizens are not the professionals (just like me), I have some of my operating procedures

Mysqldump BACKUP Database -B,--databases Dump several databases. Note the difference in usage; In This case no tables are given. All name arguments are Regarded as database names. ' Use db_name; ' would be Included in the output.

With the popularization of computers and the development of the network, the database is no longer just the topic that the programmer is proprietary. and Oracle database is by virtue of its outstanding performance, easy to operate and flexible

Oracle My environment: Machine c1200m, 128M Software RedHat Linux release 9, Kernel 2.4.20-8. I was installed by reference to other people's notes (but I saved a few steps) My Linux is completely installed and I don't have to explain anything else.

If you do not have a long DBA, the backup of the database some worry, hoping to find a way to ease your backup solution, then this article is absolutely suitable for you. On the database backup recovery principle, we are more or less familiar with.

Oracle If you go to a computer bookstore now, you'll find that books related to Oracle technology will occupy a lot of space in bookstores. In these books there are many fine, but certainly some dross mixed with, for fine, we might as well read, for