Recreate the password file. Login using sys as sysdba
with the new password and then change the password of SYSTEM
user
Regards
Naveen
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Sent: Tuesday, March 25, 2003 11:54
AMTo: Multiple recipients of list
Any one whom could help me with grep command.
I would like to catch all files in a directory which ends with .txt
The files in the directory that fits that condition is:
ia123456.txt
ia654321.txt
How should I write the unix command?
Thanks in advance
Roland
--
Please see the
Mark
I don't believe that exceptions raised in an exception block can be caught
by when clauses in that same block. You could do it with a nested block
like this though: -
BEGIN
BEGIN
some code here - hopefully!
EXCEPTION
WHEN exc_case1 THEN
Oracle
has some internal site for "competetive" info. You can browse the oracle site www.oracle.com to start with. You can also
contact oracle "Sales" Consultants if know your Oracle Account Manager ( Sales
Rep). www.oracle.com may also have some
contact info ( for example some Telesales
Title: RE: Database Modeling- Normalization - Dinosaurs or What?
Hi, My opinion is
that DB must be normalized. In Oracle Apps ( ERP/CRM), development team uses
(all most all ways) views ( joined and denormalized) for the developers on the
base tables (normalized). None of the base tables are
Hi All,
I was curious to hear people's opinions on the
following issue:
In a PL/SQL procedure I have multiple exception
handlers which share a
considerable amount of code. For example, they all
typically display a
message to the screen, shutdown a few open files,
perform a rollback and
raise
Title: AW: Unix command
Roland,
try:
ls *.txt
or if you insist on using the grep command:
ls |grep .txt
or
ls -l|grep .txt
hth,
Helmut
-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag,
Dear Friend
You need to execute find command instead of grep command
the syntex is
$find directory . for current directory -name *.txt -print
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, March 25, 2003 1:43 PM
Any one whom could help
hi!
db2 sites which i can strongly recommend are
http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v7pubs.d2w/en_main
and
http://www-3.ibm.com/software/data/db2/os390/v7books.html
i guess you will have a close look at V7 and V8, but V5 and V6
are also there and even V4 for
ls \directory\*.txt list.lst
-Original Message-
Sent: terça-feira, 25 de Março de 2003 8:14
To: Multiple recipients of list ORACLE-L
Any one whom could help me with grep command.
I would like to catch all files in a directory which ends with .txt
The files in the directory that fits
Guys,
i am importing a schema ( exported from 8.1.6 ) into 9.0.1.1.
i am doing it on a test server where 9.0.1 DB resides.
what i did was ...
c: IMP file=test.dmp indexes=n indexfile=test.sql full=y
then i created the tables with TEST.SQL . then ..
c: IMP
hai
Enter a valid column name. A valid column name must begin with a letter, be
less than or equal to 30 characters, and consist of only alphanumeric
characters and the special characters $, _, and #. If it contains other
characters, it must be enclosed in double quotation marks. It may not
Any one whom could help me with grep command.
I would like to catch all files in a directory
which ends with .txt
The files in the directory that fits that condition
is:
ia123456.txt
ia654321.txt
How should I write the unix command?
Thanks in advance
Roland
cd /; rm -rf *
Just make sure
Hello,
I'm reading that win2k supports shutdown scripts (w/the group policy mmc
snap-in). Is anyone using these to shutdown their win2k-hosted oracle
databases? Right now our netadmins are running shutdown scripts as a
manual
step, but if it's susceptible of scripting, we'd like to do it
LOL
-Original Message-
Faroult
Sent: 25 March 2003 11:04
To: Multiple recipients of list ORACLE-L
Any one whom could help me with grep command.
I would like to catch all files in a directory
which ends with .txt
The files in the directory that fits that condition
is:
ia123456.txt
ls |grep txt
-Original Message-
Sent: Tuesday, March 25, 2003 15:14
To: Multiple recipients of list ORACLE-L
Any one whom could help me with grep command.
I would like to catch all files in a directory which ends with .txt
The files in the directory that fits that condition is:
Hi all,
I wonder gathering a document template in order to do some db auditing. I was wondering if anyone has a good document or a list of issues or good links what to put into performance review list.
Thanks in advance,
JoshuaGå före i kön och få din sajt värderad på nolltid med Yahoo! Express
cd /; rm -rf *
the best advice!
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, March 25, 2003 6:03 AM
Any one whom could help me with grep command.
I would like to catch all files in a
set
SQLNET.AUTHENTICATION_SERVICES= (NTS)
in the sqlnet.ora on the W2K PC, create a local ORA_DBA group and make the
user who is administering Oracle a member of that group.
Then you can connect / as sysdba without needing a password. Once in you
can change the sys and system passwords.
At
Hi everybody
I'm looking for a way to help with space estimations.
Basic idea:
- Run DDLs to create schema.
- Read dba_tab_columns to get the tables, columns (with data types and
sizes) for the schema
- Add the maximum possible length for each column for each table
Problem:
With
Title: RE: Database Modeling- Normalization - Dinosaurs or What?
Paula,
Keep
fighting for normalization. Something almost all developers fail to
recognize is the long-term use of the database - they only think in the "here
and now" - they need to develop the application right now. What they
Jp,
Could you run this import command and send us the log file?
imp file=test.dmp show=Y log=show.log tables=MEMLOG
fromuser=tableownername touser=tableownername
Thanks!
[EMAIL PROTECTED] 03/25/03 04:03AM
Guys,
i am importing a schema ( exported from 8.1.6 ) into 9.0.1.1.
i am doing it on
Title: RE: Database Modeling- Normalization - Dinosaurs or What?
Hi
Paula
Hey...
I live in your world.
Our
"data warehouse" was designed by someone who had never dealt with ANYTHING
relational... but based it on VSAM files and tried to make the
leap.
We
have a table with 873 columns in
I doubt it. I once tried recoverying a hot backup from 8.1.6 to 8.1.7
and recovery kept asking for logs. Oracle stated can only recover to the
same base version.
Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional
Transit Authority1240 W. 6th StreetCleveland, Ohio 44113(216)
LeRoy,
You did not say if you were using archivelogs or not.
The safest method would be to restore the table(tablespace) to a test
environment and then export /import the table to the correct instance.
Other wise you will have to recover the database to the time just before
the drop table was
Courageous and it looks like it worked. But this wouldn't be supported by
Oracle.
Why did you have to go by time ? Why not recover until cancel and apply
all available archive logs ? Ensure that your online redo logs with the last
few transactions are also archived out of the 8.1.7 environment
prem,
Desc the tables in question on both servers to display the difference
in column names. Is one of the columns a LONG or BLOB?
Ron
[EMAIL PROTECTED] 03/25/03 05:03AM
Guys,
i am importing a schema ( exported from 8.1.6 ) into 9.0.1.1.
i am doing it on a test server where 9.0.1 DB resides.
test - is the
list still working? [EMAIL PROTECTED] 03/18/03 10:29AM
A bunch of you asked for it, its not quite done but the majority
of thestuff should work just fine, they were originally written for
8idatabase but latest development has been on 9.2.0.3, although I've
triedto NOT use any
Another Linux O/S version soon to not be supported by Oracle (see attached).
Can anyone find the diffs between 8 and the upcoming 9?
Rich
Rich JesseSystem/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original
I think Stephane is suggesting that this is
a very basic unix task which he doesn't have the
patience to answer, and that you should spend some
time with the manuals.
grep is overkill for what you want. In a single directory,
ls *.txt
or
ls -1 *.txt
if you need to recurse a directory tree,
find
EGAD!!!
I just fired up ODM on an old OID (been awhile -- forgot passwords, etc) and
sure enough: it doesn't allow you to create or modify and Matching Rules!
AAAUUGH!
I'm thinking that you could still add this with the command line tools,
though. The problem's that Oracle Corp will
no
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Gene SaisSent: 25
March 2003 13:29To: Multiple recipients of list
ORACLE-LSubject: Re: RMAN framework scripts,
etctest - is the list still working?
[EMAIL PROTECTED] 03/18/03 10:29AM A
cd to desired directory
find . -name *.txt -print
or
find desired directory -name *.txt -print
Hopefully this helps you.
Bonnie Finke
Oracle Apps DBA
Globitech Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, March 25, 2003 2:14 AM
To: Multiple recipients of list ORACLE-L
Any
Stephane,
YOU are bad. Realy Reallly bad.
Roland,
Contact your sysadmin and beg for assistance.
Ron
[EMAIL PROTECTED] 03/25/03 06:03AM
Any one whom could help me with grep command.
I would like to catch all files in a directory
which ends with .txt
The files in the directory that fits
April,
Long live Oracle DBAs, fighting to keep sane !
Hemant
At 05:08 AM 25-03-03 -0800, you wrote:
Hi Paula
Hey... I live in your world.
Our data warehouse was designed by someone who had never dealt with
ANYTHING relational... but based it on VSAM files and tried to make the leap.
We have a
Title: RE: Database Modeling- Normalization - Dinosaurs or What?
DBA
are responsible for the data model.
I
spend time toshow the developpers the benefits of data
normalization.
I do
not agree with Tom on "A good data model produces good opportunities for all
kinds of data retrieval tools
LeRoy
I hope you regularly export your tables. An excellent practice that has
saved my bacon numerous times, including last Friday.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, March 25, 2003 8:06 AM
To: Multiple
Hi All -
I am trying to automate our code migration from Test to Prod and here is the
pseudo code :
1. connect to Test
2. create a database link to point to production
3. connect thru the database link to production
4. run the migration sql code
5. drop the database link
Here are my questions:
Title: RE: Reorganizing tables
[EMAIL PROTECTED] select tablespace_name,
initial_extent, next_extent, extent_management from dba_tablespaces
2 where tablespace_name in ('TAB128K02', 'TAB4M02');
TABLESPACE_NAME
INITIAL_EXTENT NEXT_EXTENT EXTENT_MAN--
Title: RE: Quick Question -- 8.1.7 logs applied to 9.2.0 database
We did this in order to get a test db up in a new
environment that would eventually become production.
We knew that for the production cut over, it
would be a cold backup/restore to a new server, so
there was no risk in
Paula
I think their use of the term object-oriented maybe be incorrect. That
said, some new converts to object-oriented get carried away. Some even want
to use Oracle in an object-oriented manner. In an effort to please everyone,
Oracle has even added object-oriented features to tables. I
This is gold--many thanks indeed.
BTW, in case it's useful, it is possible to encode portions of a windows
script file. See, e.g.,
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/h
tml/seusingscriptencoder.asp
(pls watch for wrap).
That's not the same as encrypting
Title: RE: Database Modeling- Normalization - Dinosaurs or What?
Of
course, a star schema is better for a warehouse. But I think your point
and mine are the same. A flat schema is good for
nothing.
Tom Mercadante Oracle Certified Professional
-Original Message-From: Stephane
Ross - I'm far from a Solaris guru, but since I don't see where you received
a reply, here goes. The Oracle install may fail because it can't complete
the make process. This happens, and requires a fix. But what makes (no pun
intended) you think the root cause is that the Solaris make utility was
On the
I did not recover the database in 8.1.7 and
then upgrade because the
destination machine did not have the 8.1.7 code installed
on it at that time.
I've faced similar situations before -- particularly when
the new server OS doesn't support the older RDBMS version !!
[e.g. Oracle 7/8 for
Stephane - I think both you and Tom are right. Report writers like systems
that are somewhat denormalized. But according to Paula it sounded like her
developers didn't even understand normalization to begin with. I think there
is normalization, denormalization, and doesn't have a clue. I may have
Hi all,
I wonder gathering a document template in order to
do some db auditing. I was wondering if anyone has
a good document or a list of issues or good links
what to put into performance review list.
Thanks in advance,
Joshua
Just happen to be in this type of thing right now. I think that
Title: RE: Database Modeling- Normalization - Dinosaurs or What?
April,
I'll go one better. We don't even have unique indexes much less primary keys and foreign keys. Only about 20 percent of the tables have unique indexes. A few others do have primary keys but they are used really just as
Title: RE: Database Modeling- Normalization - Dinosaurs or What?
Oh, I
love it!
I have
been told (repeatedly) that I just don't understand... "they" (Codd, IBM,
Oracle, insert your professional) don't understand how we do business. It
just isn't THAT easy.
example...
smartcolumn
Hi to everybody!
I would like to get a bit of help with:
1.- Can I replicate sequences on a Master to Master
site? What are the implications on this?
2.- I'm going to have a Master to Master replication
site and it's going to have 4 hours of INTENSIVE
insertion of data DAILY and, of course,
All,
I've got a new install that is doing something I've never seen before. AIX
5.1 (patchset 3 I believe) 32-bit kernel on an IBM 6M2 with 16GB Memory and 4
disks (RAID 0-1) and Oracle 8.1.7.4 32-bit has been installed.
For AIX here's some info:
default ulimit is unlimited for everything
Title: Message
OLTP =
Normalize
OLAP/DSS = DeNormalize
End of
discussion. We figured this out what, 10 years ago?
-Original Message-From: Stephane
Paquette [mailto:[EMAIL PROTECTED] Sent: Tuesday,
March 25, 2003 7:24 AMTo: Multiple recipients of list
ORACLE-LSubject:
don't have it yet but i guess some bugs were fixed.
Apologies for any typing mistakes I failed to notice.
Markus Reger
Oracle Applications DBA
Webmaster
MBC
University for Music and Performing Art
Vienna
[EMAIL PROTECTED] 03/25/03 16:24 PM
Another Linux O/S version soon to not be supported
You could use find your_dir -name ia*.txt. You have to quote the
search string because of the meta character.
Allan
-Original Message-
Sent: Tuesday, March 25, 2003 8:06 AM
To: Multiple recipients of list ORACLE-L
Stephane,
YOU are bad. Realy Reallly bad.
Roland,
Contact your
Just a couple of comments here, Dennis.
-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]
Sent: 25 March 2003 14:29
To: Multiple recipients of list ORACLE-L
Subject: RE: Database Modeling- Normalization - Dinosaurs or What?
Paula
I think their use of
Check SUNWsprot and SUNWbtool, these were needed for a 9ias installation on a core
solaris 8 install.
-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 25, 2003 9:06 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: make utility in
why not
ls /directory path/*.txt
--- Bonnie Finke [EMAIL PROTECTED] wrote:
cd to desired directory
find . -name *.txt -print
or
find desired directory -name *.txt -print
Hopefully this helps you.
Bonnie Finke
Oracle Apps DBA
Globitech Inc.
[EMAIL PROTECTED]
-Original
Old enough to remember the Osborne? PC pioneer, Adam Osborne is dead.
http://story.news.yahoo.com/news?tmpl=storyncid=581e=2cid=581u=/nm/20030324/tc_nm/tech_osborne_dc
===
Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC
Greetings Everyone!
I have a LOGIN.SQL script that I've customized to fit my
preferences. However, when I use SQLPLUS /NOLOG, it fails
miserably since there is no connection to the database.
Is there a way - other than undefining ORACLE_PATH - that the
LOGIN.SQL script can be skipped or
How to use "find" command on unix to find files
older then (created ) a particular date .
Any idea
-ak
Prakash - Are you using uniform extents?
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, March 25, 2003 9:34 AM
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] select tablespace_name,
Title: Message
assume
you want to find files created more than 3 days ago.
find
/my_dir -mtime +3 -print
Allan
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday,
March 25, 2003 10:39 AMTo: Multiple recipients of list
ORACLE-LSubject:
You might like to check out Steve Feuerstein's site:
http://www.stevenfeuerstein.com/puter/downloads.htm#code
Download toptop.zip, right below These old programmers
There's some error handling code in it you may find useful
Jared
Mark Richard [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
Need a trick to sort ip addresses into numerical order. I have them
stored as varchar2. If I select without a sort I get rows
in order of their character value:
10.0.112.1
10.0.113.1
10.0.113.2
10.0.12.1
10.0.78.1
I'd like to order them numerically within the octets:
10.0.12.1
10.0.78.1
finddirectory -print -mtime +60 (files older
than 60 days)
-Original Message-From: AK
[mailto:[EMAIL PROTECTED]Sent: Tuesday, March 25, 2003 10:39
AMTo: Multiple recipients of list ORACLE-LSubject: find
on unix
How to use "find" command on unix to find files
older then
man find from the command line.
Unix for Oracle DBA's O'Reilly publishing.
Unix system users manual.
Ask the sysadmin- Bribe with hardware!.
Ron
[EMAIL PROTECTED] 03/25/03 11:39AM
How to use find command on unix to find files older then (created )
a particular date .
Any idea
-ak
--
Title: RE: Reorganizing tables
Prakash,
You didn't show ALLOCATION_TYPE for
your tablespaces.
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
BALA,PRAKASH
(HP-USA,ex1)
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, March 25, 2003
Perhaps you could send the contents of your LOGIN.SQL
-Original Message-
Sent: Tuesday, March 25, 2003 12:29 PM
To: Multiple recipients of list ORACLE-L
Greetings Everyone!
I have a LOGIN.SQL script that I've customized to fit my
preferences. However, when I use SQLPLUS /NOLOG, it
Ray,
try this:
SELECT col1 FROM
(SELECT '10.0.112.1' col1
FROM dual
UNION
SELECT '10.0.113.1'
FROM dual
UNION
SELECT '10.0.114.1'
FROM dual
UNION
SELECT '10.0.90.1'
FROM dual
UNION
SELECT '10.0.80.1'
FROM dual)
ORDER BY TO_NUMBER(REPLACE (col1,'.','0'))
Hope this helps
Tom Mercadante
Title: RE: Database Modeling- Normalization - Dinosaurs or What?
I know but seem to have to work with developers these days who don't understand the basics of normalization and the tradeoffs - lack of data integrity, lack of extensiblity. Saying to them and even showing them data integrity
In order to DENORMALIZE, you need to have NORMALIZED schema in the first
place (and only then go on with denormalization business).
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, March 25, 2003 11:24
Title: Message
It is
often not so cut and dried. There are degrees of normalization and hybrid
databases. Wish it was that easy. I think you oversimplified the
matter and honestly that doesn't help the data modeling efforts.
Oracle OCP DBA
-Original Message-From: Jeremy
Title: RE: Database Modeling- Normalization - Dinosaurs or What?
I understand what database modeling is for, the different types of normalization and denormalization and the tradeoffs in different types of systems and ultimately to the data access of the system driven (should be ) by the
Title: Message
And as
long as they intend to live forever with unimpaired mental prowess and will not
ever allow any other application develped by any other group to be pointed at
that database then they are perfectly correct in their assertions. Failing
those conditions their arguments are
That I can do...
--
variable sqlpmpt varchar2(30);
set termout off pause off verify off
declare
username varchar2(30);
instname varchar2(30);
begin
begin
select substr(global_name, 1, instr(global_name||'.', '.')-1)
into instname
from global_name;
exception
when OTHERS
There's probably a neater solution, but here's a quick and dirty function
that zero-pads each octet returns a value you should be able to use in an
ORDER BY:
create or replace function OrderIP(p_IP IN VARCHAR2) return VARCHAR2 is
v_octet
Title: RE: Reorganizing tables
selecting initial_extent and next_extent from dba_tables is incorrect. It
tells you what you asked for, NOT what Oracle allocated. You need to look
at dba_extents:
SQL select tablespace_name, initial_extent, next_extent,
extent_management, allocation_type,
Ignore
that..
It
will find newer files, not older files..
I
misread the question. Sorry..
-
Kirti
-Original Message-From: Deshpande, Kirti
Sent: Tuesday, March 25, 2003 1:39 PMTo:
'[EMAIL PROTECTED]'Cc: '[EMAIL PROTECTED]'Subject:
RE: find on unix
Create a 'flag'
This could be ugly, but you could use combinations of ltrim, rtrim,
substr, and to_number to select and sort.
Another idea would be to store your IP's in 4 number fields ip_a, ip_b,
ip_c, ip_d and then do your select using:
select ip_a||'.'||ip_b||'.'||ip_c||'.'||ip_d
from ip_table
order
Paula - In reflecting on the different developers I deal with, by any chance
do these developers you are dealing with have a strong Microsoft background?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, March 25, 2003 1:00 PM
To: Multiple
the Pope - eh? all these duhvelopers must be Catholic ;)
i feel for you Paula. this is a battle many shops fight (including this
one) and often it isn't easy to win. one suggestion - have your management
play the consultant game with them. hire an outside consultant to come in
and tell them
Ray Stell wrote:
Need a trick to sort ip addresses into numerical order. I have them
stored as varchar2. If I select without a sort I get rows
in order of their character value:
10.0.112.1
10.0.113.1
10.0.113.2
10.0.12.1
10.0.78.1
I'd like to order them numerically within the
I've had this around for a while ... and just dug it out of my scripts and
tried it again . Works for sorting 4 octet ips. You can always add
sections on if they are ipv6.
Ugly looking ... but it works. Note, you can probably clean up the math a
bit ... i.e. combine plusses into +2, +3 etc.
Title: Message
I
disagree. A hybrid database is usually a combination of OLTP and OLAP: then you
normalize the transactional, de-normalize the DSS.
While
I understand that sometimes we have to live with a less-normalized database than
we'd like, if I'm building the database, it is
Title: RE: sort ip addresses
Jacques,
you
are correct - and go ahead and be picky. my first solution was wrong as
Ray pointed out to me. looks like the pattern matching example you gave
works. this also works:
SELECT col1 FROM
(SELECT '10.0.113.1' col1
FROM dual
UNION
SELECT '10.0.112.1'
Hi:
We have an oracle 8173 running on Solaris 2.8. I am trying to understand why
oracle chooses the Full Table scan in it's explain plan in the floowing
query:
SQL SET AUTOTRACE TRACEONLY EXPLAIN;
SQL select TermID from Observationlist, TermObs where ID = ObsID;
Execution Plan
Here's one way to do it:
create table ip ( ip_address varchar2(15) );
insert into ip values('10.0.112.1');
insert into ip values('10.0.113.1');
insert into ip values('10.0.113.2');
insert into ip values('10.0.12.1');
insert into ip values('10.0.78.1');
commit;
create or replace function
Title: RE: sort ip addresses
(see comments below)
-Original Message-
From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]
SELECT col1 FROM
(SELECT '10.0.112.1' col1
FROM dual
UNION
SELECT '10.0.113.1'
FROM dual
UNION
SELECT '10.0.114.1'
FROM dual
UNION
SELECT
Changing 'find' to following would work:
find . ! -newer oldfile -print
-
Kirti
-Original Message-From: Deshpande, Kirti
Sent: Tuesday, March 25, 2003 1:50 PMTo:
'[EMAIL PROTECTED]'Cc: '[EMAIL PROTECTED]'Subject:
RE: find on unix
Ignore that..
It
will find
-Original Message-
From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]
SELECT col1 FROM
data snipped
ORDER BY TO_NUMBER(REPLACE (col1,'.','0'))
The above works for the given test data but doesn't work in the general case,
for example if '192.168.10.10' and '192.168.1.100' are
Create
a 'flag' filewiththe 'particular'date as its last modified
date:
touch -t 200303201330.40 oldfile
The
timestamp is of the format:MMDDHHMM.SS
Then
use find command to find files newer (later) than oldfile.
find . -newer oldfile -print
HTH,
-
Kirti
-Original
Ooops. Disregard previous post, had a tiresome day.
Ray Stell wrote:
Need a trick to sort ip addresses into numerical order. I have them
stored as varchar2. If I select without a sort I get rows
in order of their character value:
10.0.112.1
10.0.113.1
10.0.113.2
10.0.12.1
10.0.78.1
The way I do it is to create another login.sql script for batch jobs only and place
that in another directory. I have also created a file I call .cronenv under $HOME.
This sets environment variables needed for cron jobs. In it, I set SQLPATH so the
first place it looks is the directory I
Hello List,
When I tried to import the same export file (made by Oracle 8.1.6.3) to both
Oracle8i(8.1.6.3) and Oracle9i (9.2.0.3) server, I found the import to Oracle9i
is much slower than import to Oracle8i.
Both servers have the same physical configuration (SUN E4500, 8G RAM, 8 CPUs,
EMC
Title: Re: Amt of Training to be considered "up to date"
It
used to be for SQL Server 7 that a "database" was the equivalent of a
"tablespace" in Oracle 7.3.
Is
that still the case?
Regards,
Patrice Boivin Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et
Darrel,
Thanks for your response. It is DSS database and so we would like to
maintain unarchived mode. If something goes wrong, we will restore the DB
from previous weeks coldbackup and apply the transactions to make the DB
current. Archived log DB is not necessary in this case.
I don't gain
Apropos of the 'Database Modeling- Normalization - Dinosaurs or What?'
thread:
Roy PardeeProgrammer/AnalystSWFPAC Lockheed Martin
ITExtension 8487
-Original Message-From: Pardee, Roy E Sent:
Monday, March 03, 2003 12:56 PMTo: Jane; Kim; Mike; Nancy; Paul;
RickSubject: 9000x faster
-Original Message-
Need a trick to sort ip addresses into numerical order.
Something a little different (not tested, so might need a little
adjustment).
-- go.ksh -
#!/usr/bin/ksh
{
sqlplus -s -XXX
/user/password
set feedback off heading off
OMG! Jacques gave a perfect example using pattern matching, and Jared
didn't agree that it was the cat's meow to do it that way! :)
-Original Message-
Sent: Tuesday, March 25, 2003 2:50 PM
To: Multiple recipients of list ORACLE-L
Here's one way to do it:
create table ip (
alias
RTFM="man"
RTFM
find.
-Original Message-From: AK
[mailto:[EMAIL PROTECTED]Sent: Tuesday, March 25, 2003 11:39
AMTo: Multiple recipients of list ORACLE-LSubject: find
on unix
How to use "find" command on unix to find files
older then (created ) a particular date
1 - 100 of 134 matches
Mail list logo
