Discover oracle 9i, include the articles, news, trends, analysis and practical advice about oracle 9i on alibabacloud.com
Oracle It took several days to install Oracle 9i under FreeBSD 5.0RC1, although it was not successful at all. But it was a lot of gains. Because I'm not necessarily using Oracle under FreeBSD, this installation test is a bit of a waste-utilization. No success, but also a total failure. Proof at least: VIA C3 1G This C
Tags: Oracle 9iSAP R3 Oracle 9i Client InstallationThe client system is R2 64-bit for Windows Server.Oracle database services are configured in two ways: 1. Configuration during installation, 2. Configuration via NET Configuration Assistant, Oracle database services can also be defined through the Tnsnames.ora file.Aft
The ORACLE tutorial is as follows: startup after Oracle 9i Database is shut down abnormally. Oracle Database startup A sudden power failure occurs during Oracle shutdown, and the database cannot be connected when SQL/plus is used for startup. The specific description is as
Today, a friend asked me why 11g exp files cannot be imported into 9I? Due to the incompatibility of exp/imp tools, when importing a database of a higher version to a lower version, you need to use the exp/imp tool of a lower version for import and export. A friend used 9i exp to export 11G data and then import imp to 9i. The import is normal. However, I reported
Simple configuration for Oracle 9i full-text retrieval1. PrerequisitesAll Oracle 9i instances are supported by default, as shown in the following figure.The ctxsys user and ctxapp role exist in the system,The listener supports full-text retrieval, as shown below:# Listener. ora network configuration file: D:/
If the user mistakenly deletes/updates the data, as the user does not have any direct method to restore, they must help the DBA to restore the database, to the oracle9i, this embarrassing situation has improved. Oracle 9i provides a new technique--a flash-back query that allows users to get data before a bad operation in a timely manner, and to recover for errors without DBA intervention. Because the hand
Oracle 9i PGA usage control We know that Oracle has provided the automatic PGA management function since 9i. From then on, we can skip the annoying settings such as sort_area_size and hash_area_size, and do not need to compute the tedious PGA size. But how can we control the size of PGA used by each session? Will there
This article introduces the usage of different subquery brackets in oracle for 9i and 10g and 11g. if you need this, refer to the following. There is such a view, probably as follows: This view can only be compiled successfully in 10g and 11g environments, and cannot be compiled in 9i environments. The Code is as follows: Copy code Select
Oracle 9i uses flashback query to Restore database accidental deletion. oracle9i If the user accidentally deletes/updates the data, there is no direct way for the user to recover the data, they must seek help from the DBA to recover the database to Oracle9i, this embarrassing situation has improved. Oracle 9i provides
Q: Hello, I ran the following code in the Oracle 9i database: CREATE OR REPLACE TYPE persona as OBJECT (ident varchar2 (9), nombr varchar2 (30)); CREATE table Tper (per persona); INSERT into Tper values (Persona (' n ', ' Lucas ')); SELECT * from Tper; Error occurred after system notification: Ora-00932:inconsistent data type. Expected number get USUT7. Persona What is the problem, please? How can i s
In win2003 and win2000 enterprise operating systems, uninstall Oracle 9i: 1. Stop all Oracle services2. Delete All Oracle items in the Registry(1) Delete the Oracle directory under HKEY_LOCAL_MACHINE \ Software(2) Delete All Oracle
/dataLD_LIBRARY_PATH =/lib:/usr/libLD_LIBRARY_PATH =:/usr/local/libExport LD_LIBRARY_PATH Export PATH =/usr/local/bin:/usr/bin:/binCLASSPATH =/JRE:/jlib:/rdbms/jlibCLASSPATH =:/network/jlibExport CLASSPATH ###############Change or disable the ftp and http ports of Oracle XDBStarting from Oracle 9i, XDB features are included by default during database creation. O
Under the Win2000 Enterprise operating system, uninstall Oracle 9i: 1. Stop All Oracle Services 2, delete all the information about Oracle in the registry (1) Under HKEY_LOCAL_MACHINE\Software, delete the Oracle directory (2) Under Hkey_local_machine\system\controlset001
In actual work and study, many people need to export and back up the Oracle9i database. In this article, we will introduce a method for automatic execution:Step 1:Open notepad and enter:Exp test/test @ test file = D:/backup/% Date :~ 0, 10%. dmp log = D:/backup/% Date :~ 0, 10%. LogSave as "Database Export. Bat"Sid is test,The username and password are test/test,Call the exp command to generate corresponding data files and log files in the D:/backup directory.% Date :~ Is used to export files by
1. If Oracle 9i is installed, the default value in the National charset is al16utf16. If you want to change al16utf16 to utf8 Follow the previous method Update SYS. Props $ Set Value $ = 'utf8' where name = ''nls _ nchar_characterset ''; The charset information is not fully reflected in Oracle. Therefore, when inserting data in a table, the value is set to al16ut
There is no problem in running Oracle 10g environment, as shown below: For c in (SELECT * from table (pkg_1__common.f_split (P_IN_IDS _, ',') LOOP.... Omitted hereEnd loop; However, in Oracle 9i execution, the ORA-22905: cannot access rows from a non-nested table item cannot access rows from non-nested table items. Analysis: The f_split function in the pkg_1_
Constraints are the mechanisms that Oracle database systems provide to restrict the integrity of data. Oracle 9i allows the creation of 5 constraints. See table 7.8. To create a check constraint (1) In the Manage Target navigator, follow the steps in the 7.6 section to modify the datasheet structure. (2) Switch to the "Constraints" tab of the Edit table shown i
In Oracle 9i, reading char fields is inconvenient, which limits the use of char fields. to read the value of a field, use the following methods: SQL> Create Table Test ( 2 a char (5 )) 3 tablespace users; The table has been created. SQL> insert into test values ('1 '); One row has been created. SQL> insert into test values ('2 '); One row has been created. SQL> insert into test
Oracle 9i Default User Table 8.1 Oracle 9i Default Primary User User name Password Login Status and Description Sys Change_on_install Sysdba or Sysoper, but can not 訬 ormal login, as the default system administrator System Manager Sysdba or normal, but cannot be
to the database through the Management Server. 2. "Management Server" The Management Server is the middle tier that connects the database server and manages the client. A database warehouse is established on the Management Server to store administrative information from the management client, and then the administrative tasks are released to the "Smart agent" execution of the database server. To use advanced administrative features such as events, jobs, groups, e-mail, and scheduling, you must
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
