The Adventure Begins

This article is a shortened version of the full article on Installing Oracle E-Business 12.1.1 on Oracle Enterprise Linux 5.4 64-bit which can be read on Oracle-Developer.com.

I started by purchasing a brand new enterprise server without an OS. My first goal was to install the latest release of Oracle Enterprise Linux for the operating system and then to install the latest release of Oracle Database (11.2).

SQL for SAS Programmers - Introduction

What is SQL?

SQL stands for Structured Query Language and was designed for development and maintenance within a Database Management System (DBMS).

In my view, Display Manager commands didn’t get much attention of SAS programmers as they should be. It may be because...

1) SAS Documentation has very little information about how to use this facility.
2) Even Google searches aren’t helpful enough.

Here are the list of Display Manager Commands I know…

Using Manager commands we can open the dataset from any directory without touching the Explorer window…

Read more: http://studysas.blogspot.com/2009/11/sas-display-manager-commands.html

Many a time, developers ask for procedures to kill there own sessions in the oracle db.
Many of our developers are scattered around the globe in different time zones.
During on-call rotation, developers will be calling me, round the clock, to kill their sessions.

To resolve this issue, I came up with this package, consisting of a pipelined function
and a procedure. The pipelined function, displays the users' sessions in the db.
The procedure kills the developer's session only.

Here I present a simple query to use when we want to move the tables and indexes of several users at once.

To make it one by one:

ALTER TABLE xxxxxx MOVE TABLESPACE TEST;
ALTER INDEX xxxxxx REBUILD TABLESPACE TEST;

To move data from multiple owners.

Just testing things a bit. Sorry if you got spammed with this bog entry. I am posting at both OraFAQ and Oracle forums to try out the two interfaces for blog entries. Also trying blogspot.com and Google Sites.

If you have tried out the blogging and have a preference for one vs another, please let me know.

It is an English word that sounds very funny in Spanish, almost unreal.
Well, just wanted to brand the blog with a first entry to introduce myself.
I work as an Oracle and SQL Server DBA (mixed profile, they call it -
concerns twice for the same pay, on me).
Here I will write "how to" articles as they emerge in my day to day.
If you can read Spanish, check out the blog I maintain for a little more time http://blog.davidlozanolucas.com/.

Here is a script to start/stop Oracle databases running in Unix:

[code]
# =======================================================================

I saw one of those really interesting pieces of code recently. A guy wanted to run his transaction and make it fail when it was all done. Normally one would put ROLLBACK at the end of the transaction in order to undo a transaction's work. But this guy did not want to do that. He wanted to keep his transaction code unchanged, commit at the end and everything. He had several reasons for this, among them being that he did not have access to all the code he was working with and thus could not put the ROLLBACK where it was needed, and indeed suspected (as we eventually found to be true), that somewhere in the code stream there was a commit being done without his permission thus splitting his transaction in ways he did not intend. So he wanted a way to FOREORDAIN (determine ahead of time) that his transaction would fail no matter even if it went to conclusion without error. For this he came up with a I think a clever hack. Seems to me this might have some use, if I can figure out what that use might be. So here is the cool solution.

Last week I migrated some schemas from 11g database (11.1.0.6) to 9i database (9.2.0.8).

I used to export the 11g schemas using oracle 9i binary & exported successfully.
While importing 11g schema’s into 9i database I faced below issues.

Error: import done in US7ASCII character set and AL16UTF16 NCHAR character setSegmentation Fault (coredump)

Operating system: Sun Solaris 10 / 64 bit processor

Note:

I exported the 11g schema’s using 10g binary and imported into 10g database
successfully.

Recently a friend asked me for this. I see it a lot on OraFaq as a question in the forums so here are the basics of working with delimited strings. I will show the various common methods for creating them and for unpacking them. Its not like I invented this stuff so I will also post some links for additional reading.