From here (link wraps)
http://asktom.oracle.com/pls/ask/f?p=4950:8:1774479186358239817::
NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:68212348056
I copied the following code - to dump the contents of a table as a

I have losing my i18n file and i search parameters for US parameters
and 8bit ISO charsets.
Regards
Philippe

Is there anybody knows how can I save not latin dates in Oracle? I
mean for example: Jalali(shamsi) calender or Arabic Calender(Hijri)
instead of using Julian Calendar.
Currently we do this by saving this dates in varchar type and another

I just installed Oracle 9iR2 (9.2.0.1.0) in Windows XP Professional SP2.  I
selected the Personal Edition and requested a the starter database to be
created.
However, the init parameter file created is called

Does anyone has a good script which will compare all the
fields of 2 tables dymically?

hello..
in oracle 7.3.4, if i want to resize (down) the datafiles for a table space
used for indexes
but oracle refuses because the free space is not contiguous at the end of

We are using Oracle 9i R2 on Window2K.  We are planning to use SAN box for
the database.  It seems to me that the use of SAN may contradict what has
been recommanded from Oracle, say separation of database files, redo log
files, archived log files and the RMAN backup files.

Consider the following:
Database ORA1, table TAB1.
A materialized view log is created on TAB1.
Database ORA2, materialized view (read only snapshot) MV_TAB1 is

I am always needing to do something like this, but can't seem to find
the right approach:
Summary: Join 1 table to itself to summarize data based on a substring
of one of the fields.  I have read-only access to the data.

Is there a way , while doing "insert as select", to keep rejected rows
in a certain table and continue on with bulk insert?
I know you can do that through pl/sql with collections, but that would
slow my load.

I am wishing to migrate to LMT's in an Oracle 9.2 database. I am trying
to find out if this can be done with users still accessing data ie
while the database is online. I would appreciate any comments regarding
this and other problems encountered. We are probably going to have to

Before i use an Oracle8.0.4 on AIX 4.3.2 and i could store $FF value
in VARCHAR2 type.
Now i have an Oracle9.2.0.4 on Redhat and $FF are translated to $7F,
I could not use RAW type

OK, I have created a package. Im kind of new at this stuff so stupid
mistakes are going to happen. My question is how do you check to see if
your API code is working correctly. Whenever i run it from sql plus,
the procedure is created with errors..

there i a shared pool problem ( ORA 4031 )
version 8.1.7.4
OPS
HP-UX

At the risk of being incomplete, what, other than the ORACLE_SID determines
what instance a user connects to?