- Oracle | install | oracle |SYSDBA - Системный Администратор Баз Данных - Oracle, MSSQL, DB2 IBM, Sybase ASE, MySQL, PostgreSQL, Interbase/Firebird Установка, Администрирование баз данных, Настройка производительности баз данных, Установка баз данных, книги, статьи, sql, plsql, t-sql,exam,sertification

Все |0-9 | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z

| А | Б | В | Г | Д | Е | Ж | З | И | К | Л | М | Н | О | П | Р | С | Т | У | Ф | Х | Ц | Ч | Ш | Щ | Э | Ю | Я

Советы

Oracle

Поиск по тегам : Советы, Oracle, How to Loading LOBs into Oracle using SQL*Loader, How to Use Oracle9i SPFILE to overcome traditional PFILE Limitations, how to find permanent tablespace for a database, What is the DATABASE_PROPERTIES data dictionary view?

Результаты 1 - 20 из 38

1. SQL*Plus Tips

Советы / Oracle

Currently 0.00/10
1
2
3
4
5
6
7
8
9
10

Рейтинг 0.0/10 (0 голосовать)

Connect as SYS Oracle has long warned of the removal of the Server Manager (SVRMGRL) product as well as the ability to issue the CONNECT INTERNAL command. In Oracle 9i you can connect internal as user SYS as ...

2. how to find permanent tablespace for a database

Советы / Oracle

Currently 1.00/10
1
2
3
4
5
6
7
8
9
10

Рейтинг 1.0/10 (1 голосовать)

I do not understand how can I find permanent table space for my database. I tried follwing queriy but the result is negative: SQL> SELECT property_value 2 FROM database_properties 3 WHERE property_name = 'DEFAULT_PERMANENT_TABLESPAC...

3. How to use Undo Tablespace instead of Rollback Segments

Советы / Oracle

Currently 3.00/10
1
2
3
4
5
6
7
8
9
10

Рейтинг 3.0/10 (2 голосов)

Historically, Oracle has used rollback segments to store undo. Space management for these rollback segments has proven to be quite complex. Oracle now offers another method of storing undo that eliminates the complexi...

4. How to Monitoring Unused Indexes in Oracle 9i

Советы / Oracle

Currently 3.00/10
1
2
3
4
5
6
7
8
9
10

Рейтинг 3.0/10 (3 голосов)

Oracle 8i introduced table-usage monitoring to help streamline the process of statistics collection. To automatically gather statistics for a particular table, enable the monitoring attribute using the MONITORING ...

5. How to install Oracle Enterprise Manager grid

Советы / Oracle

Currently 3.00/10
1
2
3
4
5
6
7
8
9
10

Рейтинг 3.0/10 (2 голосов)

This is very common task – running 64 bit server with numerous Oracle components, but need to install Oracle application (such as a database OR Grid Control Server) which is not released for x86_64 platform, but works on i386 platform. Th...

6. How to install 10g EM Grid Control Installation

Советы / Oracle

Currently 2.50/10
1
2
3
4
5
6
7
8
9
10

Рейтинг 2.5/10 (2 голосов)

Download and unzip the 10.2.0.1 GRID CONTROL software from http://technet.oracle.com Software for this installation copied to /ora_export/backup/grid emrep:/ora_export/backup/grid> export DISPAY=10.254.101.183:0.0 emrep:...

7. How to send email from 10g Oracle Database (UTL_MAIL)

Советы / Oracle

Currently 3.00/10
1
2
3
4
5
6
7
8
9
10

Рейтинг 3.0/10 (1 голосовать)

Heres a simple solution to send out emails from 10g Database sql prompt. This solution will be really helpful if the OS utility (mailx, sendmail) is restricted for end users. Steps to enable Mailing from Database 1. sqlplus ‘/ as sysdba&r...

8. What is the DATABASE_PROPERTIES data dictionary view?

Советы / Oracle

Currently 3.50/10
1
2
3
4
5
6
7
8
9
10

Рейтинг 3.5/10 (2 голосов)

The DATABASE_PROPERTIES data dictionary view lists the permanent database properties. Some of the properties of the DATABASE_PROPERTIES data dictionary view are given below: property_name property_value description Pass OCA, 10g New Feature for...

| 143 Посещения | Печать | PDF | Email

9. How to Connecting Oracle DB without TNSNAMES entry

Советы / Oracle

Currently 4.00/10
1
2
3
4
5
6
7
8
9
10

Рейтинг 4.0/10 (2 голосов)

There are several possibilities to connect a client application to an Oracle database. The client uses a resolution method to resolve a connect identifier to a connect descriptor when attempting to connect to a database ...

10. How to unload data in a format for SQLLDR to reload later

Советы / Oracle

Currently 4.00/10
1
2
3
4
5
6
7
8
9
10

Рейтинг 4.0/10 (2 голосов)

Sometimes you need a simple way to transfer one or more tables from Oracle to Oracle. If you have a network connection to both databases you can use the INSERT / SELECT statement. However if the databases are located in protecte...

11. How to turn on and off the ARCHIVELOG mode in oracle?

Советы / Oracle

Currently 4.00/10
1
2
3
4
5
6
7
8
9
10

Рейтинг 4.0/10 (2 голосов)

1. Turning on ARCHIVELOG mode: We consider a database that is not in ARCHIVELOG mode and also automatic archival is not enabled. To see the status of the database we can use of the following SQL commands: SQL> select log_mode from v$databas...

12. How to use Suspending and Resuming a Database

Советы / Oracle

Currently 5.00/10
1
2
3
4
5
6
7
8
9
10

Рейтинг 5.0/10 (1 голосовать)

The ALTER SYSTEM SUSPEND statement suspends a database by halting all input and output (I/O) to datafiles (file header and file data) and control files, thus allowing a database to be backed up without I/O interference. ...

13. How to Extract Object DDL and XML Definition from Oracle 9i

Советы / Oracle

Currently 5.00/10
1
2
3
4
5
6
7
8
9
10

Рейтинг 5.0/10 (1 голосовать)

The Oracle 9i Metadata API provides an interface that allows you to extract Oracle DDL (Data Definition Language) from the data dictionary. This eliminates the need to query the data dictionary views to etract the obje...

14. How to skip columns with SQLLDR

Советы / Oracle

Currently 5.00/10
1
2
3
4
5
6
7
8
9
10

Рейтинг 5.0/10 (1 голосовать)

Overview How can you load a file full of delimited data and load just some of the columns, skipping over fields you don't want. You cannot use the SQLLDR syntax POSTION(x:y) because it is stream...

15. How to setup the desired DATE Display Format in Oracle

Советы / Oracle

Currently 5.00/10
1
2
3
4
5
6
7
8
9
10

Рейтинг 5.0/10 (1 голосовать)

In date expressions, SQL and PL/SQL automatically converts character values in the default date format to DATE values. The default date format is set by the Oracle initialization parameter NLS_DATE_FORMAT. For exampl...

16. How to resolve Concurrency Problems and Isolation Levels

Советы / Oracle

Currently 5.00/10
1
2
3
4
5
6
7
8
9
10

Рейтинг 5.0/10 (1 голосовать)

Overview Databases such as Oracle and Microsoft® SQL Server™ 2000 uses locking to ensure transactional integrity and database consistency. Locking prevents users from reading data being c...

17. How to Install Oracle 11g Release 2 on OEL 5.4 on VirtualBox: Installing Grid Infrastructure

Советы / Oracle

Currently 4.50/10
1
2
3
4
5
6
7
8
9
10

Рейтинг 4.5/10 (2 голосов)

In Oracle 11g Release 2 you will find that things have changed even for single instance database installation. I will try to illustrate in this series of posts how to install a single instance Oracle 11g Release 2 database to your Linux machines....

18. Перенос базы с одного компьютера на другой Oracle

Советы / Oracle

Currently 5.00/10
1
2
3
4
5
6
7
8
9
10

Рейтинг 5.0/10 (1 голосовать)

В таком случае самым простым будет следующее: 1. Сконфигурировать ОС на будующем сервере 2. Установить на будующий сервер Oracle RDBMS. 3. Создать структуру дирректорий в которых располагаются файлы данных по аналогии с работающим в данный момен...

| 33 Посещения | Печать | PDF | Email

19. How to create Standby database creation without any RMAN backups

Советы / Oracle

Currently 5.00/10
1
2
3
4
5
6
7
8
9
10

Рейтинг 5.0/10 (1 голосовать)

Quick steps to set up a 11g Standby database with Active Data Guard using the Active Duplication feature available in 11g where we can create a standby database without having to take a backup on the primary database. Datafiles are copied over the...

20. How to Data Pump Export (expdp) and Data Pump Import(impdp)This is a featured page

Советы / Oracle

Currently 5.00/10
1
2
3
4
5
6
7
8
9
10

Рейтинг 5.0/10 (1 голосовать)

Oracle introduced Data Pump in Oracle Database 10g Release 1. This new oracle technology enables very high transfer of data from one database to another. The oracle Data Pump provides two utilities namely: Data Pump Export which is invoked with t...

<< [Первая] < [Предыдущая] 1 2 [Следующая] > [Последняя] >>


Вернуться	Лучшие

Последние добавленные статьи