Re: *.dbf, *.ctl, redo*.log access rite

We have: -rw-r- for all of them Mike Sinardy Xing wrote: Hi guys, Can you tell me what is your access rite for those files in unix solaris 7 oracle 8.1.6, my current access rite are: rwxrwxr-x for all of them. Sinardy -- Ing. Michal Zaschke DB Administrator

RE: Where can I find Information about the MSDOS commands?

I think you are more looking for the oradim utility. If I understand correctly, you would like to create and delete services? If so, go to msdos, and simply type oradim, this will take you in to the utility, and give syntax for what you need. HTH Mark -Original Message- Messer Sent:

too much space after import

Hello listers , I am in the process of migrating an application from oracle 7.1 on openvms to oracle 8.1.7 standard edition on NT , so i do an export and import. everthing is ok except that the new data take too much space in the new database. the exported file size is only 8MB , but it took

RE: HELP...Sizing our hardware for Oracle's 11i Apps

Title: RE: HELP...Sizing our hardware for Oracle's 11i Apps Hi, In doc A83525-01 Maintaining Oracle Applications there's some information such as shared_pool 300 M (at least) etc. Rule of thumb for one installation of apps 11i y'll need 1 Gb memory (at least) depending on how many forms

RE: Where can I find Information about the MSDOS commands?

I should think they are mostly listed in the Oracle Utilities Manual. Search for this under the documents for NT section on http://otn.oracle.com HTH Mark -Original Message- Martinez Jimenez Sent: Monday, April 02, 2001 09:56 To: Multiple recipients of list ORACLE-L Yes, I know

RE: Where can I find Information about the MSDOS commands?

Almost every DOS command used to have its help associated if you use "/?" parameter after the command e.g., COPY /? HTH! Aleem -Original Message- Sent: Monday, April 02, 2001 1:56 PM To: Multiple recipients of list ORACLE-L Subject:Re: Where can I find Information about

AUTHID CURRENT_USER across DATABASE LINK

Hi Gurus ! Is it any way to use effects of AUTHID CURRENT_USER clause in stored procedures stored in a remote database? I mean, I have to instances , but I want to store stored procedure only once, and use the same procedures on local and remote tables. Thanks in advance. Gyula -- Please

RE: SQL Server basic sources of info?

Chris, Here's some stuff from a SQL Server DBA who is now learning the joys of Oracle. 1. Some useful links (swynk is probably the best) http:/www.microsoft.com/sql http://msdn.microsoft.com/sqlserver/ http://www.swynk.com/sysapps/sql.asp http://www.sqlmag.com http://www.mssqlserver.com Get a

Which CD?

On which installation CD can I find sqlloader setup? Roland Skldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

Help with sqlloader

Hi folks, (See attached file: mondaytest.txt)(See attached file: describetable.txt) Can anyone help me to write a ctl-file, for instance called test.ctl, to use when i use sqlloader to import a textfile into the oracle database? I am including two files here, which you might need. Thanks in

How to use Perl / DBI on NT

I typically use Apache with mod_perl, perl perl DBD, perl DBI on Linux. I would like to set-up a similar environment on my laptop for a demo I am giving. Has anyone set this up? If so, what is the best approach to do so Oracle 9iAS (does it even come with mod_perl)? Or Apache for

RE: Which CD?

You can find it either on CD for Oracle Client or CD for Database (inside Oracle Utilities). HTH, Sonja -Original Message- Sent: Monday, April 02, 2001 1:15 PM To: Multiple recipients of list ORACLE-L On which installation CD can I find sqlloader setup? Roland Skldblom

RE: Which CD?

The same on that you installed the Server from. Install the utilities. -Original Message- Sent: Monday, April 02, 2001 7:15 AM To: Multiple recipients of list ORACLE-L On which installation CD can I find sqlloader setup? Roland Skldblom -- Please see the official ORACLE-L

Re: Good Oracle Apps listserv?

This is a good one too: == O R A C L E A P P L I C A T I O N S L I S T S E R V E R (On the Internet) -- The Oracle

RE: Which CD?

Oracle Enterprise Edition or Oracle Standard Edition. You can try custom installation to they should be sqlldr there. -Original Message- [EMAIL PROTECTED] Sent: Monday, 2 April 2001 7:15 PM To: Multiple recipients of list ORACLE-L On which installation CD can I find sqlloader

Re: RevealNet

Interesting. We have had no problems with getting our upgrades and the sales droids have been very helpful and cooperative. (Don't know anything about cost. Too far down the line to have a need to know). Terry [EMAIL PROTECTED] wrote: Ravindra, We had it and dropped it. Cost was more

Re: Help with sqlloader

Roland. Listed below is a sample of a control file and par file that I use to load data such as yours each day. Modify the control file and par file to suit your needs, such as list your column names, data file name, etc. CONTROL FILE: Load Data Append Into

RE: Which CD?

You can do custom installation and sqlldr is part of UTILITIES. Rick -Original Message- From: Sinardy Xing [SMTP:[EMAIL PROTECTED]] Sent: Monday, April 02, 2001 8:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: Which CD? Oracle Enterprise Edition or Oracle

DBA Studio

Hi, I only used SQL*PLUS or the old enterprise manager 1.6.x so far. Now I decided to give the Java tools a try. Unfortunately, upon startup of DBA Studio, I'm getting a "File tnsnames.ora could not be analyzed, Error: 100 -- NLNV-NLNV String Format Error". What does this mean and what can I do

RE: meeting of list participants working in DC area

Title: RE: meeting of list participants working in DC area That's a great picture.he sounds like a spunky guy. ;-) ||-Original Message- ||From: Marc Perkowitz [mailto:[EMAIL PROTECTED]] ||Sent: Friday, March 30, 2001 6:20 PM ||To: Multiple recipients of list ORACLE-L ||Subject:

Re: In Praise of Metalink

Hi, by the way, where can I get any Patches etc. without having access to Metalink. Our customer purchased Oracle, but no support. And they have version 8.1.6.0.0. Isn't ther 8.1.6.2.0 already ? Jim Conboy schrieb: Since I've complained loudly when Metalink stinks I feel obligated to give

Re: *.dbf, *.ctl, redo*.log access rite

you should kept your datafiles in 640 too to protect your data oli [EMAIL PROTECTED] wrote ..dbf = -rw-r--r-- ..ctl = -rw-r- ..log = -rw-r- sam -Original Message- Sent: Monday, April 02, 2001 8:05 AM To: Multiple recipients of list ORACLE-L Hi guys, Can you tell

Services and Oracle Startup - WIN2000

I have this small situaltion I try to start my database from command line in win2k , I get the following error C:\svrmgrl Oracle Server Manager Release 3.1.6.0.0 - Production Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved. ORA-12560: TNS:protocol adapter error SVRMGR

OT: DB2 forums/listserves

Hi people, I am being thrown head first in to learning DB2's verison of SQL, and was wondering if any of you guys and gals out there know of any good DB2 list servers, forums, newsgroups etc.. Thanks for any info, Mark (Going to cry now) Leith BEGIN:VCARD VERSION:2.1 N:Leith;Mark FN:Mark

Re: RevealNet

I have been using RevealNet Knowledgebase and Instant Messages for a couple years now I find them indispensible. IMHO, I think its what the Oracle online docs should be. Ravindra Basavaraja wrote: Gurus, I wanted some inputs on Revealnet knowledge base.If anyone is using this,i want to

Oracle start/stop scripts on AIX

Who said unix is unix, not me. I have worked w/ HPUX, Digital Unix, Linux, and Solaris. All of these support some form of automatic shutdown/startup scripts found in rc.d directorires, etc. I can not believe IBM AIX uses the /etc/inittab for the startup and you have to create a wrapper

OT- Metalink : Always when you need it the most

Request Failed We were unable to process your request at this time. Error occured while accessing "/metalink/plsql/tar_main.this_tar" at Mon Apr 02 07:58:53 2001 OWS-05101: Execution failed due to

Oracle on NT - Slow performance

We are having problems with slow response time on Oracle 8.1.6 on an NT server. The slow response time occurs even where are no users on the server. Sometime the logon takes 30 seconds. I noticed the following sql is being executed by the system quite a few times and does a lot of buffer

RE: Services and Oracle Startup - WIN2000

It's a bug. Refer to note 132086.1 on Metalink. -Original Message- Sent: Monday, April 02, 2001 10:31 AM To: Multiple recipients of list ORACLE-L I have this small situaltion I try to start my database from command line in win2k , I get the following error C:\svrmgrl Oracle

RE: SQLPLUS hangs

Please clarify "it just sits there". Do you lose your cursor? Does it come back to a Unix prompt? Are you running Unix? Michael Armstead Database Administrator, OCP-Certified Corporate Finance Information Systems Glaxo SmithKline -Original Message- From: SHAIBAL TALUKDER

Re: Oracle start/stop scripts on AIX

I just use dbstart, the one that comes with Oracle. It works for us on AIX 4.2.1. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Monday, April 02, 2001 11:50 AM Who said unix is unix, not me. I have worked w/ HPUX, Digital Unix, Linux,

RE: SQLPLUS hangs

Truss or strace will probably give you more information. -Original Message- Sent: Monday, April 02, 2001 11:25 AM To: Multiple recipients of list ORACLE-L Hi Folks, Could you pls shed some light. My SQLplus log in hangs when I am trying to log in. As soon as type SQLPlus it just sits

OEM Repos install error.

Hi Everyone, Just a quick one, I am installing OEM 2.1 on to a Win2K box, with Oracle 8.1.7 already installed on it. When running through the Configuration Assistant, to create a new repository, I am getting the following error: --- java.io.FileNotFoundException:

Re: DB2 forums/listserves

Just email to L-Soft list server at RYCI.COM (1.8d) which is [EMAIL PROTECTED] Write this in the message SUBSCRIBE DB2-L Your Name. HTH, Ruth - Original Message - To: "Multiple recipients of list

Veritas

The subject of Veritas came up at work today, and I'm curious. How widely used is Veritas in Oracle environments? Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org -- Please see the official

RE: OT- Metalink : Always when you need it the most

Oh now, that's completely normal. Kev -Original Message- stephane Sent: Monday, April 02, 2001 12:01 PM To: Multiple recipients of list ORACLE-L Request Failed We were unable to process your request at

No Subject

Hello, when is WAIT information written to event10046 raw trace file ? after each WAIT or another mechanism such as cummulative writes after a specified count ? if it's after each WAIT, I will be able to calculate some statistics not given in P1,P2,P3. thanks in advance... =

Re: Oracle start/stop scripts on AIX

AIX has same startup and shudwon scripts like Solaris. From: "Ruth Gramolini" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Oracle start/stop scripts on AIX Date: Mon, 02 Apr 2001 08:35:22 -0800 I just use dbstart, the one

Re: Oracle start/stop scripts on AIX

Thanks Ruth. Guess I wasn't clear in my question. Do you call the oracle startup script from inittab and the oracle shutdown script from a wrapped shutdown script? Or is there a way to call these scripts from rc.local or rc2.d, rc0.d, etc. when performing a shutdown/startup of AIX? [EMAIL

RE: DB2 forums/listserves

Thanks Ruth! Mark -Original Message- Gramolini Sent: Monday, April 02, 2001 05:35 To: Multiple recipients of list ORACLE-L Just email to L-Soft list server at RYCI.COM (1.8d) which is [EMAIL PROTECTED] Write this in the message SUBSCRIBE DB2-L Your Name.

RE: 8.1.6.3.1. patch causing problems?

FYI Oracle Support just called me back, apparently I was using the "old" version of the 8.1.6.3.1. patch, they retired it and re-introduced a "new" 8.1.6.3.1. patch in February. Since then they produced patches 8.1.6.3.2, 8.1.6.3.3, and 8.1.6.3.4. All since February. They asked me why I

RE: Veritas

I use it. Kev -Original Message- Gennick Sent: Monday, April 02, 2001 12:46 PM To: Multiple recipients of list ORACLE-L The subject of Veritas came up at work today, and I'm curious. How widely used is Veritas in Oracle environments? Best regards, Jonathan Gennick mailto:[EMAIL

Long Raw Problems

OK, I admit it. In 3 years as a DBA I haven't had to deal with a single LONG RAW column. BLOB, CLOB and BFILE yes LONG RAW, no. So here is my Monday morning challenge. I had a database hose itself on Sunday. I rebuilt the database, but it is still misbehaving (looks like hardware). I can't get

Re: Oracle start/stop scripts on AIX

On Mon, 2 Apr 2001, Gene Sais wrote: Who said unix is unix, not me. I have worked w/ HPUX, Digital Unix, Linux, and Solaris. All of these support some form of automatic shutdown/startup scripts found in rc.d directorires, etc. I can not believe IBM AIX uses the /etc/inittab for the

RE: OEM Repos install error.

Hi Mark, I installed 2.1 several times, nothing like this (never on the same box with 8.1.7). I'm pretty sure, you need either separate ORACLE_HOMEs for 8.1.7 and OEM 2.1, or go with OEM 2.2, as Clint told. Vadim Gorbounov Oracle DBA -Original Message-

Re: How to use Perl / DBI on NT

On Mon, 2 Apr 2001, Babette wrote: I typically use Apache with mod_perl, perl perl DBD, perl DBI on Linux. I would like to set-up a similar environment on my laptop for a demo I am giving. Has anyone set this up? If so, what is the best approach to do so Oracle 9iAS (does it even come

RE: Long Raw Problems

Todd, You can't use Insert Into...As Select From... with Long or Long Raw columns. One solution that I've used is to write an anonymous PL/SQL block that loops through a cursor on your source table, capturing each source row in a PL/SQL record, then Inserting into your target table using the

Re: Oracle start/stop scripts on AIX

I just call it. It is in the ORACLE_HOME and know where to find oratab. The only unix box I have ever worked on is AIX and I am still learning. I guess I was too naive to worry about where everything was supposed to be I just did what the book said. The shutdown script is a bit of a problem

Re: DB2 forums/listserves

My pleasure. I don't have to much to do with DB2 because we use it for a canned application from IBM but I keep subscribed just in case. I don't like the SQL much. Regards, Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Monday, April 02,

Re: *.dbf, *.ctl, redo*.log access rite

On Sun, 1 Apr 2001, Sinardy Xing wrote: Hi guys, Can you tell me what is your access rite for those files in unix solaris 7 oracle 8.1.6, my current access rite are: rwxrwxr-x for all of them. Sinardy Regardless of what they are, they should be set to 0640. This allows r/w for Oracle,

Re: Oracle start/stop scripts on AIX

On Mon, 2 Apr 2001, Raghu Kota wrote: AIX has same startup and shudwon scripts like Solaris. No, it doesn't. On Solaris you will find the familiar /etc/rc.d setup. AIX does not use this, but rather relies exclusively on inittab and a single klunky shell script. Jared -- Please see the

Re: Services and Oracle Startup - WIN2000

It worked for my just now. Terry Apps Sol wrote: trying to connect to the oracle ftp site for bugs and it's giving me a timeout.. using this address 203.227.44.220 . is this the right none ..? rk - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]

RE: Veritas

Jonathan, We use Veritas NetBackup with Oracle 8.1.6 under Win2k. The vendor-supplied command and RMan scripts work nicely on our 200+ GB database. We had a problem with intermittant failures earlier this year and the issue got escalated to their development group, which supplied a patch that

Re: Services and Oracle Startup - WIN2000

Works fine with ftp://oracle-ftp.us.oracle.com HTH Srini Chavali Oracle DBA Cummins Inc Apps Sol [EMAIL PROTECTED]@fatcity.com on 04/02/2001 12:37:06 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:

RE: Veritas

Title: RE: Veritas Jack (or anyone), we have a predicament with the Sun version of Netbackup and Quick I/O when used with RMAN. RMAN cannot create a backup of the special link along with the actual data file. On a restore, only the data file is copied back to disk, in effect turning the Quick

comments on tool

Hello, Anyone using a product called Oros Links, from ABC technologies? Someone apparently did a good sales job on a manager here, and they have requested we "look" at this product. We have an Oracle8i warehouse here running on Solaris, and my understanding is that this product will be used to

RE: Long Raw Problems

That worked. How simple! I was looking for something much more complicated. KISS. I assume that PL/SQL is doing a conversion on the datatype that SQL doesn't. Thanks Jack! Todd Carlson Oracle 8i Certified DBA Bunge Corporation

Re: Oracle start/stop scripts on AIX

Ruth Gramolini wrote: The shutdown script is a bit of a problem because it does a shutdown normal and may hang forever so I just shut them down individually. i always edit the scripts to do a shutdown immediate. seems to work most of the time. -- Bill Thater Certifiable ORACLE DBA

Re: Oracle start/stop scripts on AIX

I think I may try that. I haven't been too adventurous with UNIX. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Monday, April 02, 2001 2:55 PM Ruth Gramolini wrote: The shutdown script is a bit of a problem because it does a

RE: sql*loader default value

Greg, look into the 'defaultif' option. Prakash -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, April 02, 2001 2:50 PM To: Multiple recipients of list ORACLE-L When using direct path loads, is it possible to have sql*loader insert a default value in place of NULL for

Re: Oracle start/stop scripts on AIX

my inittab cantains rc.local, and it calls rc.oracle which calls dbstart. Gene Sais wrote: Thanks Ruth. Guess I wasn't clear in my question. Do you call the oracle startup script from inittab and the oracle shutdown script from a wrapped shutdown script? Or is there a way to call these

Re: Oracle start/stop scripts on AIX

my inittab cantains rc.local, and it calls rc.oracle which calls dbstart. Robin Gene Sais wrote: Thanks Ruth. Guess I wasn't clear in my question. Do you call the oracle startup script from inittab and the oracle shutdown script from a wrapped shutdown script? Or is there a way to call

Revoke - Alter - Users

I am trying to revoke alter table capability for some users as system and sys and it's not . What's the best way to stop users from altering any table structure and disabling any constraints ?? RK -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Apps Sol INET:

Oracle DBA Needed in Rochester, New York..Top Notch Company

*Description: Top notch client in Rochester New York needs an Oracle DBA to join its' I.T. team. Responsibilities include: installations and maintenance of Oracle software, providing input to design, security, capacity requirements and account administration. Will also assist in developing

RE:

After each wait. -Original Message- Sent: Monday, April 02, 2001 1:20 PM To: Multiple recipients of list ORACLE-L Hello, when is WAIT information written to event10046 raw trace file ? after each WAIT or another mechanism such as cummulative writes after a specified count ? if it's

Re: Confused with v$session and v$process

Mitchell, By hostname I take it you mean the hostname of the server where oracle is installed. I believe that you can call the server anything you want because the ODBC driver looks up the hostname in the tnsnames.ora and gets the ip address from the host file you are calling from. If you use

RE: Revoke - Alter - Users

Please correct me if I'm wrong. I thought you could only revoke that access if you were the schema owner. Michael Armstead Database Administrator, OCP-Certified Corporate Finance Information Systems Glaxo SmithKline -Original Message- From: Apps Sol [SMTP:[EMAIL PROTECTED]]

SQLServer vs. Oracle Papers Needed

I need pointers to papers/studies that compare and contrast SQLServer vs. Oracle. I'm specifically looking for studies which appear impartial and conclude that Oracle is the better choice. Thanks in advance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Pall

RE: Veritas

Here's a very exhaustive survey... On my Oracle Open World badge the following sponsers were represented: Oracle, IOUG, EMC, HP, Intel, Sun, Veritas. :-) Steve Orr -Original Message- Gennick Sent: Monday, April 02, 2001 9:46 AM To: Multiple recipients of list ORACLE-L The subject of

Performance issue

HI, I have a table with 1 million records, If I search for one value of a column it comes very fast and if I do the same query for a different value on the same column it takes more time. I did not understand why it behaves like that. Any ideas.. Thanks kiran -- Please see the official

RE: ORACLE-L Digest -

Title: RE: ORACLE-L Digest - ORACLE-L NODIGEST

RE: Linux ver and Oracle

I've found RH6.2 and Oracle 8.1.7.0.1 to be pretty compatible. Don't know about the other Linux distributions. Richard -Original Message- Sent: Monday, April 02, 2001 4:16 PM To: Multiple recipients of list ORACLE-L List, I am playing with the idea of loading my PC with Linux and

Insufficient privs to connect internal

Hello, I am running oracle 8.1.6.1.3 on NT 4.0 and am having difficulties attempting to connect internal from SQL*Plus. From a DOS prompt logged in as the Oracle user which has full administrative rights... c:\set ORACLE_SID=sidname c:\ sqlplus /nolog SQL connect internal Enter Password:

RE: Performance issue

Title: RE: Performance issue -Original Message- From: Pampati, Kiran [mailto:[EMAIL PROTECTED]] I have a table with 1 million records, If I search for one value of a column it comes very fast and if I do the same query for a different value on the same column it takes more

RE: Insufficient privs to connect internal

Check your SQLNET.ORA. You should have: SQLNET.AUTHENTICATION_SERVICES= (NTS) in it to verify your NT id as a user with database rights Greg -Original Message- Sent: Monday, April 02, 2001 5:52 PM To: Multiple recipients of list ORACLE-L Hello, I am running oracle 8.1.6.1.3 on NT

Diff between local and network connection

I have a unix server and when i connect to a db i can make a connection by doing sqlplus /@db and connect through the listener or sqlplus / without a connect string and it takes my current Oracle sid and makes a local connection my question is what is the difference between the 2 types of

Re: Veritas

In my experience (which is predominantly Solaris), the moment you get to a reasonably sized installation, virtually everyone seems to be using in some way or the other... In basic form - managing UFS file systems "Next level" - managing vxfs file systems "Next level" - with raw or Quick IO

Re: How do you turn off MTS?

Yep... Comment out anything prefixed with mts_ and you're away hth connor --- "Smith, Ron L." [EMAIL PROTECTED] wrote: I have a new instance that for some reason is running MTS. The only MTS parameter in the startup file is mts_dispatchers = "(protocol=TCP)". Is this what started MTS?

RE: Insufficient privs to connect internal

Hmmm, OK, that works. Obviously my understanding of what this parameter does was completely incorrect. Can someone explain this to me please. I thought this was only necessary for remote authentication by a windows workstation. Thanks. At 02:16 PM 4/2/01 -0800, Nelson, Greg wrote: Check

RE: Insufficient privs to connect internal

Greg, It is my understanding that it is only necessary to set SQLNET.AUTHENTICATION_SERVICES= (NTS) if oracle is going to be relying on the client NT workstation for authentication. Is that not correct? Also, in my situation I am invoking SQL*Plus and SVRMGRL from the command prompt in a DOS

RE: Diff between local and network connection

If your client resides in a different machine than the DB server, it would the exactly the same, 'cause your are connecting to your server through the listener. However, in a UNIX environment if you connect as local, that consumes less resources since your are running on IPC protocol which is

RE: Performance issue

Try to rebuild your index and use another tablespace for that (It'd be better having a different disk). Also, be aware about how defrag is your data onto disk. That affects tremendously the performance. HTH, Jordi -Original Message- From: Pampati, Kiran [mailto:[EMAIL PROTECTED]]

Qualifying columns to improve performance?

At a course some years ago, we were told that in join statements, we should qualify ALL our column names with the appropriate table name, not just those that may be ambiguous. The reason was that the parser would not need to spend time checking multiple tables to determine thetable to which

sql query

I found a query to get the time 5 seconds less than the current time as select to_char(sysdate-5/(24*3600),'dd-mon- hh24:mi:ss') from dual; I am really not sure as to why 24*3600 is used for. Can anyone tell me why it is used. Thanks Ravindra -- Please see the official ORACLE-L FAQ:

Re: sql query

It's because Oracle dates are stored as a real number, where the integer portion represents the date and the decimal portion represents the time. This means you can do date arithmetic simply by adding or subtracting numbers to a date, where 1.0 = one day, 2.0 = two days, etc. This means

RE: Script to reverse engineer all objects in a schema to DDL?

Chris, You could use a program such as TOAD which is available for download that can extract DDL statements. There are other programs such as SQL Navigator, DB Artisan, EZSQL are available but requires you to purchase a copy. Otherwise use export and import with indexfile or show=y options.