ORACLE-DBA-ENCICLOPEDIA.BLOGSPOT.COM

oracle-datawarehousing.blogspot.com

ORACLE DATAWAREHOUSE

All about Data Warehousing with Oracle. Error Logging and Handling. You can modify a dimension using the ALTER DIMENSION statement. You can add or. Drop a level, hierarchy, or attribute from the dimension using this command. Referring to the time dimension mentioned earlier, you can remove the. Attribute fis year, drop the hierarchy fis rollup, or remove the level fiscal. Year In addition, you can add a new level called f year as in the following:. ALTER DIMENSION times dim DROP ATTRIBUTE fis year;.

oracle-db-admin.blogspot.com

Oracle DBA in the making

Oracle DBA in the making. Knowledge is all about sharing. Wednesday, February 9, 2011. The following methods are valid for backing-up an Oracle database:. Exports are "logical" database backups in that they extract logical definitions and data from the database to a file. It is a set of files needed to recover from any sort of database failure, we can create it (redundancy set) using the User managed/RMAN utility backups. It comprises of the following files:. Golden Rule of Backup. It is recommended that...

oracle-db-faq.blogspot.com

Oracle

IMP: ORA-12560 TNS:protocol adapter error. I am trying to import a schema dump on Oracle XE database on my Windows XP machine. Here is the command I am using. Imp myuser file=mydump.dmp fromuser=myuser touser=mynewuser. I didn't get any problem when I use the same command for importing another schema on local database. Not sure why I am getting this error now. IMP: ORA-12560 TNS:protocol adapter error. You need to specify the user and database name when you have more then one. Links to this post. MyTable...

oracle-db.info

オラクル【Oracle】データベース情報局 | オラクル【Oracle】のことならオラクルデータベース情報局！Oracledeデータベースの初歩から応用までを紹介しています。

オラクル Oracle のことならオラクルデータベース情報局 Oracledeデータベースの初歩から応用までを紹介しています。 Select to char(sysdate,'EEYY/MM/DD','nls calendar=' Japanese Imperial' ') from dual;. Select to date('平成22/03/15','EEYY/MM/DD','nls calendar=' Japanese Imperial' ') from dual;. ALERTファイルを除くトレースファイルの最大サイズはMAX DUMP FILE SIZE 単位 ＯＳのブロック数. サーバー側とクライアント側にインストールされ両者の通信を受け持つネットワークインタフェース これで良い ちゃんと定義せよ ミドルウェアと呼んではいけない. Oracle Netのサーバ側プロセスをリスナーと呼び、リスナー パラメータ (listener.ora) ファイルで構成します。 Windows ORACLE HOME network admin. Quit exit : LSNRCTLのイグジット.

oracle-dba-database-administration.com

Oracle dba and database restore recovery coaching resource and programs

FREE Book and Sign-up. Unix for Oracle DBA. Database Restore and Recovery Coaching from Flavia D’Souza who is known for delivering Results. Best Kept Secrets of database restore and recovery. To restore and recover your oracle database faster than the average business. Xa0;Click  . Xa0; for more info. Lavia brings AWARENESS of how restoring your database just 30 minutes faster, after an unexpected system downtime or an outage could SAVE thousands of dollars for your company. She has been a full time data...

oracle-dba-enciclopedia.blogspot.com

oracle

Subscribe to: Posts (Atom). View my complete profile. Simple theme. Powered by Blogger.

oracle-dba-faq.blogspot.com

Oracle

Oracle Technical Interview FAQ's. Sunday, April 1, 2012. CCNA Chapter Answers, CCNA 3 Answers, CCNA 3 Final Exam Answers 2012, final exam ccna 3 answer 2012. Links to this post. Subscribe to: Posts (Atom). How to Get/Gain Real Time Experience/Exposure as a DBA! Dear Blog Readers, Every now and then I do receive e-mails from the novice DBAs saying that: “We could not perform well at the interview. FIRST ROWS vs ALL ROWS. HowTo: Create a universal UDM report page in OEM. It happened to me this week! ENUM i...

oracle-dba-for-beginners.blogspot.com

Oracle CORE DBA

This blog is maitained for Oracle Professionals. Monday, June 25, 2012. To install Oracle GoldenGate, the following steps are required:. Setting ORACLE HOME and ORACLE SID. Setting library paths for dynamic builds on UNIX. Preparing to install Oracle GoldenGate within a cluster. Installing Oracle GoldenGate on Linux and UNIX. Installing Oracle GoldenGate on Windows. Integrating Oracle GoldenGate into a cluster. Installing support for Oracle sequences. Links to this post. Least one Replicat process. The a...

oracle-dba-interview-questions.blogspot.com

Oracle DBA Interview Questions

Oracle DBA Interview Questions. Oracle DBA Interview Questions. Sunday, 14 July 2013. Oracle DBA Interview Questions. 1 Which of the following does not affect the size of the SGA. B) Redo log buffer. 2 A set of Dictionary tables are created. A) Once for the Entire Database. B) Every time a user is created. C) Every time a Tablespace is created. D) None of the above. 3 The order in which Oracle processes a single SQL statement is? A execute, parse, fetch. B execute, fetch, parse. C parse, execute, fetch.

oracle-dba-online.com

Tutorial for Oracle. Learn Oracle DBA with Examples

Tutorial for Oracle SQL. Oracle DBA Interview Questions. Most asked Oracle DBA Interview Questions. 42 Backup and Recovery Questions. Unix For Oracle DBA 20 Questions. Overview of Oracle Grid Architecture. Difference between cluster and grid. Creating Database using SQL. Creating DB in 12c using DBCA. Creating DB in 12c using SQL commands. Managing Oracle 12c Container Databases. Creating Users in Oracle 12c. Managing Pluggable Databases in Oracle 12c. Unplug and Plug databases in CDB's. Restrictions on ...