Oracle Q&A Archive (1)
Auto-commit
in Stored Procedure(p3)
Block
size and performance(x5)
Can
I delete archived redo log files?(b22)
Can
I name a primary key?(t11)
Can
PL/SQL return multiple results?(p7)
Can
trigger and Store Procedure run by itself?(p9)
Case
sensitive(s11)
Commit
question(m25)
Control
file question(f5)
Data
file timestamp(m18)
Database
link(n12)
Do I
have to use SEQUENCE?(t6)
How
big a rollback segment sould be?(m24)
How
date is stored in Oracle?(m29)
How
many cursor can be opened in Oracle?(m30)
How
nested tables,trigger work?(t33)
How
REDO log works?(m23)
How
to audit user logins?(a1)
How
to break a lock?(m15)
How
to bypass rowid?(t55)
How
to calculate segment size?(t45)
How
to call *.exe program in SP?(p6)
How
to call stored procedure in SQL*PLUS?(s23)
How
to change NLS_SESSION_PARAMETER? (m37)
How
to change column size?(t32)
How
to change contents of primary key?(t20)
How
to change dbname of startup database?(f6)
How
to change password for Internal?(a3)
How
to change sysdate?(p4)
How
to change the column order?(t27)
How
to check Intelligent Agent?(n2)
How
to check query time in PL/SQL?(p12)
How
to check the parameter from table?(f3)
How
to check the size of SP?(p19)
How
to compare a date to sysdate?(s2)
How
to compile a ProC program?(p14)
How
to connect internal?(s1)
How
to connect to different database?(n7)
How
to convert from Char to number?(m13)
How
to create a database?(i1)
How
to create a new instance in AIX?(i13)
How
to create a public table?(t30)
How
to create and start first instance after install Oracle on NT?(i7)
How
to create SEQUENCE?(t14)
How
to create temporary table?(t49)
How
to create this view?(v4)
How
to create views?(v3)
How
to debug database link(dblink)?(n4)
How
to delete all rows from table without drop it?(t54)
How
to determine DB_BLOCK_SIZE?(f7)
How
to determine table usage with query?(t52)
How
to disable archive log?(a6)
How
to disable rollback segment?(m35)
How
to do array fetch and array insert?(s18)
How
to do batch jobs using OEM?(o3)
How
to do online backup?(b19)
How
to drop a column of a table?(t13)
How
to drop a database?(i15)
How
to drop schema?(t25)
How
to dynamicly create table name?(p5)
How
to execute SQL script from a command file?(s13)
How
to export a file bigger than 2GB?(b16)
How
to find a table's primary key?(t9)
How
to find database character set?(m42)
How
to find duplicates?(s25)
How
to find length of a number?(t16)
How
to find Oracle Instance Names?(m16)
How
to find out last time a table accessed?(t46)
How
to find out last time a table updated?(t38)
How
to find right EXTENTS?(t36)
How
to find size of tablespace from export file?(b24)
How
to find tablespace information?(t37)
How
to find the difference between dates?(m27)
How
to find total space size?(t19)
How
to generate a insert file?(b14)
How
to generate random number with Oracle?(m26)
How
to get all stored procedure?(p8)
How
to get connect time and logon time?(a10)
How
to get constraint values?(m43)
How
to get current sequence number?(t31)
How
to get current space of a table?(t26)
How
to get date interval?(m40)
How
to get dynamic PL/SQL?(p21)
How
to get error return code to Unix?(s19)
How
to get execution time of selecting from table?(s17)
How
to get full sql of a view?(v5)
How
to get new sequence number?(p2)
How
to get output from trigger?(p10)
How
to get sysdate in SP?(p1)
How
to get this function?(p18)
How
to grant execute to packages?(a12)
How
to handle change computer name?(m20)
How
to handle large database in NT?(m50)
How
to handle the password?(a2)
How
to identify my session?(m52)
How
to import only stored procedure?(b5)
How
to improve performance of archive log mode?(b23)
How
to improve performance of import?(b15)
How
to insert a black into a non-NULL column?(t12)
How
to insert many records in short time?(b26)
How
to insert values having quote?(s12)
How
to install multiple Oracle?(i5)
How
to integrate Oracle with e-mail?(m51)
How
to know the space a table takes?(t5)
How
to know version of Oracle?(m8)
How
to load data from DB2 to Oracle?(m36)
How
to lock multiple rows?(m7)
How
to login as sysdba?(a9)
How
to make X views available to user?(v8)
How
to monitor table usage?(t57)
How
to mount database exclusively?(m9)
How
to move a table from a tablespace to another?(t21)
How
to move control files?(m39)
How
to move database to another machine?(i20)
How
to pass table name to SP?(p17)
How
to pass variable to a procedure?(p22)
How
to prevent automatic disconnection?(n18)
How
to query remote database?(n3)
How
to read multiple rows using ODBC?(m31)
How
to recover data dictionary?(t22)
How
to recover database after a crash?(b27)
How
to recreate Oracle environment with data?(b8)
How
to re-create views?(v6)
How
to release row lock?(m46)
How
to rename a tablespace?(t23)
How
to re-org the tablespace?(x8)
How
to run SQL*Plus script in batch?(s10)
How
to select based on summary?(s24)
How
to select first row of a table?(s5)
How
to send e-mail from within Oracle?(m28)
How
to set archive mode?(a11)
How
to set ARCHIVELOG?(f4)
How
to set db_domain?(n21)
How
to set NLS_DATE_FORMAT?(m47)
How
to set prompt?(s6)
How
to set rollback segment grow automatically?(m45)
How
to set system privilege?(a13)
How
to set the format of DATE?(t8)
How
to set the sequence?(t39)
How
to set/change date format?(m53)
How
to show instance name in SQL*PLUS?(s15)
How
to silence svrmgrl?(m38)
How
to solve locking problem?(t10)
How
to solve net8 configure problems?(n22)
How
to specify the default database?(t44)
How
to start an instance?(i4)
How
to start listener?(n1)
How
to stop and start instances from batch?(i2)
How
to stop of outputting into listener.log file?(n13)
How
to take floor of date?(s26)
How
to track user activity?(a4)
How
to update a trigger?(p15)
How
to update table statistics?(t53)
How
to UPPERCASE data automatically?(m49)
How
to use bitmap index?(t48)
How
to use cascade delete?(s9)
How
to use cursor in Oracle?(m34)
How
to use days between function?(s3)
How
to use DBMS_JOB?(p24)
How
to use escape char in a query?(s22)
How
to use host command in PL/SQL?(p25)
How
to use NFS mounted device?(n16)
How
to use OS passwd?(a14)
How
to use RECOVER?(b1)
How
to use sequence and ordered query?(s20)
How
to use SP?(p20)
How
to use sqlload and skip columns?(b3)
How
to use sqlloader with date mask?(b17)
How
to use sysdate?(s16)
How
to use truncate table in PL/SQL?(p26)
How
to use where in query?(s21)
How
to utilize the RAID set?(i16)
How
to view primary keys for a table?(t40)
How
to work with SQL*Loader and trigger?(b20)
Is any
size limit when using export?(b4)
Is any
way to set num of failed attempt?(s4)
Is dropping
table logged?(a5)
Is it
a bug with V$SQLAREA table(v1)?
Is it
going to save space to use VARCHAR2 instead of CHAR?(t7)
Is
there cascading delete function in Oracle?(t51)
Licensing
questions (m33)
Linux
installation 1(i8)
Linux
installation 2(i11)
Lost
rollback files(m22)
Max
Extents reached(t3)
Numeric
datatype question(t50)
Oracle
and NT event log file(m17)
Oracle
e-certification(m11)
Oracle
server for NT or Unix?(i6)
Oracle
Statistics(m12)
Performance
and hard drive(x4)
Performance
using raw vs. file(x9)
Physical
disk vs logical drives(i14)
Primary
Key and Constraint(t29)
Problem
with redo logs(b25)
Query
Challenge 1(s7)
Question
about v$parameter(v9)
Rollback
segment(f1)
Should
I use long integer?(m19)
SQL
question(s8)
SQL*Loader
and CSV file(b18)
SQL*Loader
Question(b13)
SQL*NET
and ODBC(n11)
SQL*NET
listens on more than one IP(n20)
SQL*NET
vs Net8 for Oracle8(n6)
SQLNET
and firewall(n19)
Storage
Structure(t24)
Table
extents(t15)
Table
more than 255 columns(t56)
Temp
segment(m32)
Temporary
table space(t2)
Trigger,
SP and tablespace(p23)
What
a instance means?(m2)
What
are extents?(m3)
What
are these errors when install in AIX?(i21)
What
are top 5 responsibilities of a DBA?(m44)
What
happens if a listener is restarted?(n17)
What
is Enterprise Edition offering?(m21)
What
is a datafile?(i9)
What
is default tablespace?(f2)
What
is differ of 8.0.4 and 8.0.5?(m10)
What
is incremental import/export?(b21)
What
is kproc process in Oracle8 AIX?(m14)
What
is max length of a tablename?(t1)
What
is max size of varchar?(t35)
What
is maximum for primary key?(t34)
What
is NVL function?(m48)
What
is Oracle Async I/O?(i12)
What
is proper size of SGA?(f8)
What
is Redo Log?(m5)
What
is relation of datafile size and performance? (x7)
What
is the default password?(a8)
What
is the difference between Oracle 8 and Oracle 8 Enterprise?(m41)
What
is the difference between SP and package?(p16)
What
is the difference between startup exclusive and startup mount exclusive?(i18)
What
is the importing sequence?(b10)
What
is the opposite of ASCII function?(t28)
What
is the password file?(a15)
What
is the relation between SGA and import utility?(b11)
What
is the serial type in Oracle?(t42)
What
is the usage of snapshots?(r1)
What
is tnsnames.ora file?(n5)
What
kind data type available?(t18)
What
parameter _disable_logging for?(f9)
What
the permission a datafile should be?(i19)
When
to use SQL*Loader?(b9)
Where
is sqldba in Oracle 8.0.4?(m6)
Where
is the password file?(a7)
Where
the constraint name comes from?(t17)
Which
column should have index?(t43)
Which
datafile a table is in?(m4)
Which
index Oracle is using?(p13)
Which
table has fields infor about an index?(t4)
Which
user dba views belong to?(v2)
Which
utility to use and load file?(b7)
Why
cannot connect using Service Discovery?(n9)
Why
connection is so slow for Oracle NT?(n14)
Why
creating view failed?(v7)
Why
DBWR is slow?(x10)
Why
get error "Failed to authenticate"?(o1)
Why
getting some error after install?(i17)
Why
got error to create primary key?(t41)
Why
import takes so long?(b2)
Why
insert takes so long?(x3)
Why
is NT/Oracle is so slow?(x1)
Why
it is so slow when loading?(b6)
Why
it SQL take so long?(x2)
Why
it takes long time to connect?(n10)
Why
job execution got problem with OEM?(o2)
Why
listener has memory leak?(n15)
Why
losing space when deleting records?(b12)
Why
Oracle refuse to start?(i10)
Why
pick CHAR over VARCHAR2?(m1)
Why
rollback segment is too small?(i22)
Why
snapshot is too old?(i3)
Why
SQL*Net is slow?(n8)
Why
SYSDATE shows wrong time?(s14)
[HOME]
