Hi gurus,
Our database is running on Dynix in a Sequent machine.
I tried to put the startup/shutdown script we use in crontab and
schedule it.
I call a script shut.sh which in turn will call the shutdown.sh
script. But it gives me an error saying svrmgrl- not found. I've
given here those
Title: RE: Re[2]: Certification
I don't think you get the lapel badge anymore which makes it harder to flaunt (unobtrusively)
John
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 18 July 01 17:06
To: Multiple recipients of list ORACLE-L
Subject: Re[2]:
Title: RE: Command History in SQL*PLUS
KIrti,
That looks useful for svrmgrl but in sqlplus it shows the password as it is being typed in
(ok if you use sqlplus internal I suppose).
Is there any fix to that.
Is there an alternative to ied for other flavours of Unix (ied does not exist on
Title: RE: Oracle listener security patch -
You can't get more secure than that!
John
-Original Message-
From: John Lewis [mailto:[EMAIL PROTECTED]]
Sent: 19 July 01 00:01
To: Multiple recipients of list ORACLE-L
Subject: Oracle listener security patch -
Just installed
Title:
I Have installed Oracle XML Parser for plsql and Oracle
xml parser for java.I am trying to fetch xml from a url .I have performed
following activitiesfrom sys database user 1) Created a
class file and load it in database through
loadjava public class PropertyHelper{
public static
Title: RE: Oracle Apps customization help working with consultants
Kathy,
A lot of issues there but they all seem to boil down to one thing.
What is the remit of your job? Are you responsible for ensuring standards are in place , are consistent and are maintained.
If so then get stuck in
Did you run @?/rdbms/admin/catldap.sql ?.
Regards.
--- [EMAIL PROTECTED] wrote:
Hello Oracle Gurus.
This time i tried to run the EMP trigger example
given in Oracle Internet
Directory Application guide with LDAP/PLSQL API.
I created the trigger with the script trigger.sql
under
Title: RE: Backup script giving error when run by cron
Probably your profile not being run correctly from the cron. We have several boxes (Tru64) where even though we are using cron from the oracle account we need to use the following syntax
00 19 * * * su - oracle -c '/usr/local/bin/script'
Hi,
curiously, I've begun to have problems with alter session
statements after applying this patch for 8.1.6.3 on Solaris.
But maybe it is not due to the patchset, because I've applied it on 2
servers and I'm only having problems in one of them, the production
one!!!
Have you ever seen this kind
SET ORACLE-L NOMAIL
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Blum, Marc
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
hi list,
dbms_utility.get_hash_value converts
a string into its hash value..
how do we get back the original value
while selecting the entire record.
TIA
Saurabh Sharma
[EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html
Hallas John wrote:
Probably your profile not being run correctly from the cron. We have
several boxes (Tru64) where even though we are using cron from the
oracle account we need to use the following syntax
00 19 * * * su - oracle -c '/usr/local/bin/script'
otherwise the .profile is not
Saurabh Sharma wrote:
hi list,
dbms_utility.get_hash_value converts a string into its hash value..
how do we get back the original value while selecting the entire
record.
TIA
Saurabh Sharma
[EMAIL PROTECTED]
http://www.geocities.com/saurabh00pc/stride.html
You can't. A hash
hi list,
can anyone pls explain
it.
i've found a datafile related to a
new tablespace TABSPACE_2 ( not created by me) in v$datafile view. the path of
datafile is also ambiguous..
i.e. something like..
DISKA:TABSPACE_FILE2.DAT
no full path is shown.. and also i
could'nt find the file on my
Yes Christian
I have run @?/rdbms/admin/catldap.sql
and Package DBMS_LDAP has been installed in sys user.
When i run ldapadd command line command then again i got the exception
saying parent directory not found.
How should i create a parent directory i.e. Directory container with o=acme
I installed personal ORACLE 8.1.7 on Win98 and have a lot ofproblems. Does personal ORACLE 8.1.7 compatible with win98?
Thanks
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: ef 8454
INET: [EMAIL
Hi all,
Do you guys know how to
select column
order by time of insert into table.
Thank you,
Sinardy
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San
What is the name of the column where you keep the time the record was inserted into
the table?
-Original Message-
From: Sinardy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 19, 2001 8:55 AM
To: Multiple recipients of list ORACLE-L
Subject: Urgent Select statement SOS
Hi
Yes it is. I have it installed and it works fine. What problems are you havging
Rick
--
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--
Sinardy,
Try something like this...
INSERT INTO table_name (SELECT column_name FROM (SELECT column_name FROM
table_name ORDER BY time))
HTH
Shailesh
-Original Message-
Sent: Thursday, July 19, 2001 8:55 AM
To: Multiple recipients of list ORACLE-L
Hi all,
Do you guys know how
John,
Yes, thanks for pointing that out. The password will be displayed when using
'ied'. I have not found any solution to that, and the way 'ied' works I
doubt if there is any workaround. Sorry.
The script I mentioned will suppress the password, but I think it will be
displayed when recalling
Not unless you are using 9i (Timestamp column) or you store the sysdate as a
column.
Oracle does not make any guarentees on the order of rows in a table.
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
Title: Message
Yes,
of course
"Walking on water and developing software from a
specification are easy if both are frozen."
Christopher R. Spence Oracle DBA Fuelspot
-Original Message-From: ef 8454
[mailto:[EMAIL PROTECTED]] Sent: Thursday, July 19, 2001 8:35
AMTo:
The main problem with Oracle 816 64 bit Solaris is
that is it so late behind in term of patches.
8163 is not available yet !
--- [EMAIL PROTECTED] a écrit : Last time that I
installed Oracle 8.1.6 on a Sun 64
bit OS I installed the
64 bit version. If you pressed me real hard as to
why I
Kathy,
I would also say welcome to the world of consultants. In the last 15 years
of working with these beltway bandits I have seen both good and bad. To get a
good outcome the statement of work (SOW) needs to be VERY specific as to what
they are to do, how they document it, who and when
Bah, Microsoft Visual Assembler XP for Oracle Edition is much better.
Screaming code and everything is just three clicks.
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent:
This traffic is perfectly on topic of the list and I am sure a lot of us
would love to hear other people's stories.
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent:
www.ixora.com.au has many many scripts for such tasks.
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Tuesday, July 17, 2001 10:05 PM
To: Multiple recipients of list
That is dependent on their being a date of last posting or similar column in the
table. If not then it depends. Assuming the table is inserted into ONLY and
there have been NO deletes, then a simple 'select * from table_name' will
extract the data in the order that it was most likely inserted,
Boy have you got that right. If we're talking about a couple of hundred rows,
most likely on one log file, then yeah logminer may help. But on the other hand
if we're talking about a few thousand rows over a several log files!!
Sheesh, what a pile of work that would be!!
Dick Goulet
Wednesday, July 18, 2001, 9:06:20 PM, Chuan Zhang wrote:
CZ What are the benifits of having a support contract?
All joking aside, I wouldn't want to manage a database
without having a support contract. With support, you have
something to fall back on when you can't solve a problem
yourself.
Dear List,
One of our developers is getting following error while trying to connect
using IIS Server (4.0) to oracle Database 8.1.6.2.0. I think he is using ASP
program to connect to database.
I am able to connect though sqlplus.exe from that machine but not through
the IIS Server connection.
It's a bug, it is somewhere on metaqlink
Walking on water and developing software from a specification are easy if
both are frozen.
Christopher R. Spence
Oracle DBA
Fuelspot
-Original Message-
Sent: Wednesday, July 18, 2001 1:16 PM
To: Multiple recipients of list ORACLE-L
Hi All,
Check out his ODBC connection in ODBC administrator. It can be very interesting
what they put in there!!
Dick Goulet
Reply Separator
Author: Naik; Sandesh S [EMAIL PROTECTED]
Date: 7/19/2001 6:40 AM
Dear List,
One of our developers is getting
Hey all,
There is also the generic solution to all of these problems:
Use emacs. Esc-X shell. Run sqlplus, or any other command, natively. Use
regular emacs editing commands to access your history, copy and paste
results into other buffers, search and replace, etc.etc.etc. Even write
emacs
Dick,
I guess i didn't understand the question right. I think you are right and
before digging into the logminer it has to be seen how long a period of
inserts are we talking about.
Shailesh
-Original Message-
Sent: Thursday, July 19, 2001 9:18 AM
To: Yadav; Shailesh; Multiple
Good point.
paquette stephane
stephane_paquette@To: Multiple recipients of list
Title: RE: Questions about Oracle World Wide Support
Chuan,
Without a support contract you better hope that you can get yourself out of every single recovery disaster that can possibly happen. If your data isn't important, then don't purchase a support contract. If you know everything
The only way you can do this is to store SYSDATE into a column in the table when
you insert the row and to use that column value to order the rows when you
SELECT from the table.
Yoiu can generate the date from an ON INSERT trigger.
Cheers,
Mike Hately
Oracle DBA
-Original Message-
Hi all,
A friend of mine is having a problem so I thought I would ask all of you
experts a quick question. On a Solaris 8 box running 8.1.7, if a partition
fills up, will it crash the box? I know that on NT this is very possible
depending on pagefile and what file is filling up the
Hello Sinardy,
You can only do this if you have a timestamp column in the
table, and if you use a trigger (or some other mechanism) to
set it. Oracle doesn't track the time of insert for you.
Best regards,
Jonathan Gennick
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com *
this is a joke?
Visual Assembler XP by MS? For *Oracle*
Is this the world's best oxymoron,
or what?
-Original Message-
Sent: Thursday, July 19, 2001 10:15 AM
To: Multiple recipients of list ORACLE-L
Bah, Microsoft Visual Assembler XP for Oracle Edition is much better.
Screaming
Does anyone have a Perl script that will concatenate the date records with
the detail records from the alert log? I want to grep for error messages in
the alert log but I want the date as part of the record.
Thanks!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
Title: RE: Urgent Select statement SOS
Do you have a timestamp column?
-Original Message-
From: Sinardy [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, July 19, 2001 8:55 AM
To: Multiple recipients of list ORACLE-L
Subject: Urgent Select statement SOS
Hi all,
Do you guys know how to
Kevin Kostyszyn wrote:
Hi all,
A friend of mine is having a problem so I thought I would ask all of you
experts a quick question. On a Solaris 8 box running 8.1.7, if a partition
fills up, will it crash the box? I know that on NT this is very possible
a disk partition or a
On Thu, Jul 19, 2001 at 07:16:19AM -0800, Smith, Ron L. wrote:
Does anyone have a Perl script that will concatenate the date records with
the detail records from the alert log? I want to grep for error messages in
the alert log but I want the date as part of the record.
--
great idea, why
Looks like they are doing most things right. Instead of fighting with them
I would try to learn as much as possible from them.
Alex Hillman
-Original Message-
Sent: Wednesday, July 18, 2001 7:01 PM
To: Multiple recipients of list ORACLE-L
First some background
We are running on Unix
Title: RE: Oracle Apps customization help working with consultants
You
have hit the nail on the head. I realized late yesterday that I needed to
get some standards in place here quick so I don't have deal
with this stuff. Since I am the first DBA here, I will probably be playing
a big role
I observe a 5-10 second delay, between the time I enter my passwd and
when the sqlplus prompt is presented at different random times. If I
drop that connection and login immediately there is no delay. If I
wait some unknown time period the behavior returns. This leads me to
think some package
Hi Gang,
When you click on the help icon of Applications 11i does it take you to
metalink or does it reference a file on the host machine?
TIA,
-Rocky
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
Shrek,
It's a disk partition.
KK
-Original Message-
William
Sent: Thursday, July 19, 2001 11:55 AM
To: Multiple recipients of list ORACLE-L
Kevin Kostyszyn wrote:
Hi all,
A friend of mine is having a problem so I thought I would ask all
of you
experts a quick
HPUX 11i 64 bit
Oracle 8.1.7.1 32 bit
I am creating a new database and decided to go with locally managed
tablespaces. I was going to go with autoallocate because the best I can
tell the only possible drawback with this is a little wasted space.
However, I was under the impression that you
Users are complaining of getting the following messages Oracle PL/SQL Error
Code : -1089 Error Description : Error in sleep - ORA-01089: immediate
shutdown in progress - no operations are permitted
..even when there is no shutdown in progress...nothing in the alert log?
Then the messages go
It depends. If a root partition fills up then it could crash the box. Otherwise, if
it's for the database, it might crash the database depends on what's on that partition.
HTH
Richard Ji
-Original Message-
Sent: Thursday, July 19, 2001 11:55 AM
To: Multiple recipients of
Thursday, July 19, 2001, 12:42:33 PM, Kimberly Smith wrote:
KS However, I was under the impression that you could not specify a next in the
KS storage clause of a table creation. Yet you can. So what happens if I have
KS a next defined? Do they pretty much just throw that away or should I
Not positive but I would think Oracle just ignores the NEXT parameter in
locally managed tablespaces
Rick
-Original Message-
Sent: Thursday, July 19, 2001 12:43 PM
To: Multiple recipients of list ORACLE-L
HPUX 11i 64 bit
Oracle 8.1.7.1 32 bit
I am creating a new database and decided
If Database will be running in archived log mode then in most cases oracle
db crash otherwise Database operation will hang up and user will not able to
enter any transaction.
-Seema
From: Thater, William [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
You canuse any storage parameters you like but oracle will ignore them exept
for initial for LMT with autoallocate. I would personally do not use
autoallocate. Also you cannot use autoallocate for temporary tablespace and
shouldn't use it for rollback.
Alex Hillman
-Original Message-
With LMT, Oracle allocates extents the way the
tablespace was created even if you specify storage at
the table level.
--- Kimberly Smith [EMAIL PROTECTED] a
écrit : HPUX 11i 64 bit
Oracle 8.1.7.1 32 bit
I am creating a new database and decided to go with
locally managed
tablespaces. I
We are about to do an 'emergency' upgrade from 8.1.6 to 8.1.7 on NT 4.0.
Since this is the first time we are doing this on NT, I am wondering if
anybody on the list who has been there, done that, and let us know what
kind of caveats we might run into or just outline the steps we should go
The size of extents that are managed locally are determined by the system.
The LOCAL clause of the extent management specifies this menthod in create
statement.
Sunil Nookala
Dell Computer Corp.
Austin, TX
-Original Message-
Sent: Thursday, July 19, 2001 11:43 AM
To: Multiple recipients
Of course of you go to Google and type free ocp training a site I'm quite
fond of might come up...
http://www.google.com/search?sourceid=navclientq=free+ocp+training
- Ethan
-Original Message-
Sent: Wednesday, July 18, 2001 6:21 PM
To: Multiple recipients of list ORACLE-L
Hi friends :
What can I do for send html text using UTL_SMTP.
I have knowledgement using normal text but not with html.
Regards.
Thanks.
Eriovaldo
[EMAIL PROTECTED]
Brazil
_
Seja avisado de novas mensagens do Hotmail e use o
hi,
i have an ora-7372 message when i do a simple select on a table.
what can i do for resolve that.
i'm on hpunix oracle 7.3.4
thanks in advance
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Djaroud Salim
INET: [EMAIL PROTECTED]
Fat City Network Services
Actually, I discovered that you cannot use it for the rollback tablespace
either. Oh, you can create the tablespace no problem but then you cannot
create the rollback segments in it. Something that the doco failed to
mention.
I did catch the temporary one in the doco though.
-Original
We are looking for an Oracle DBA for Lake County, Illinois.
Lake County is:
NORTH ~ Wisconsin/Milwaukee
SOUTH ~ Cook County, IL/Chicago
EAST ~ Lake Michigan
WEST ~ McHenry County, IL
Duties will include:
Software installs, performance tuning, recovery of a variety of Oracle
database
Take a look at the Oracle 8i Mogration Guide, part number A86632-01 (available on
Technet). In particular, review all the steps in Chapter 7. You can either have the
installer do the migration for you, or do it manually. I just did a migration from
8.1.6 to 8.1.7.1.3 on NT 4 Sp6a following
Take a look at the UTL_HTTP package if you want to send and get HTTP
requests. I built a little cross database communication system using this
and ASP pages. One database could post a message that would be picked up by
another database across firewalls since HTTP is usually open. However I
Kevin Kostyszyn wrote:
Shrek,
It's a disk partition.
KK
OK, if the partition hits 100% then nothing can get written to the
disk. if it has something like /var/temp on it that's bad. but i've
had them hit 100% with datafiles on them and the database keep going
because of the way
Kimberly,
Keep in mind that when you use LMT autoallocate option that the extents can grow at a
different sizes. The Autuallocate option allows
Oracle to take control of the extent allocation. Oracle will use extent
sizes of 64KB, 1MB, 8MB, and 64MB to manage space in the tablespace. The
table
But I am having rollback segments using LMT.. I am on 8.1.5...
-Original Message-
Sent: 19 July 2001 18:57
To: Multiple recipients of list ORACLE-L
Actually, I discovered that you cannot use it for the rollback tablespace
either. Oh, you can create the tablespace no problem but then
For the record, this isn't a migration, it's an upgrade.
A migration is changing your database to a new version.
An upgrade is a new release.
8.1.6 - 8.1.7 is a new release, and an upgrade according to Oracle.
Migrations imply much more work than an upgrade.
Jared
On Thursday 19 July 2001
Interesting, sort of the same thing that happens on NT. Anyway, I am not
sure what is going on at their shop. Seemingly everything is running fine,
DB, OS, DB in archive log mode, then when they shut it down to do a cold
back up the machine takes a big crap on itself. I don't know anything
On Thursday 19 July 2001 10:56, Kimberly Smith wrote:
Actually, I discovered that you cannot use it for the rollback tablespace
either. Oh, you can create the tablespace no problem but then you cannot
create the rollback segments in it. Something that the doco failed to
mention.
It is the autoallocate that it complains about. Not even sure
why I would have wanted to use autoallocate anyway but you
have to give it the uniform size parameter.
-Original Message-
Sent: Thursday, July 19, 2001 11:47 AM
To: Multiple recipients of list ORACLE-L
But I am having
Title: RE: Solaris 8 Question
Seema you are describing a full arclog destination. That isn't a crash. It's just a hung state. Fixing this problem does not require any sort of recovery. It is easy to get out of this situation gracefully.
Lisa Koivu
Seat Warmer
Ft. Lauderdale, FL, USA
I did not find on metalink how to upgrade and change
the wordsize from 64bit to 32bit.
Yes, I'm tired of waiting for patches that never
come...
--- Jared Still [EMAIL PROTECTED] a écrit :
For the record, this isn't a migration, it's an
upgrade.
A migration is changing your database to a
On Thursday 19 July 2001 10:56, Kimberly Smith wrote:
Actually, I discovered that you cannot use it for the rollback tablespace
either. Oh, you can create the tablespace no problem but then you cannot
create the rollback segments in it. Something that the doco failed to
mention.
Ah, never
After our ugprade to 817 from 815 and fully following all the procedures in
the manual ended up with the foll. objects as invalid.
Question is how do you compile objects with type being TYPE ?
SQL select substr(owner,1,10),substr(object_name,1,30),object_type from
dba_objects where status
Guess I really have to learn to write in full sentences, which
will be hard since I don't even talk that way. Its the autoallocate
you can't use. I created it just fine with the uniform size.
Sorry for the confusion everyone.
-Original Message-
Sent: Thursday, July 19, 2001 10:59 AM
Usually on a Unix system when the file system is created, there is a small percentage
of space reserved for the root. The disk will fill up and could still function because
of the space reserved for root. If not taken care of right away the full disk space
could become a full physical disk and
Title: local connection using pro-cobol
I have a pro-cobol application running on my database server. I am trying to use a local connection in a pro-cobol program but I get an ora-12154 error if I do not have the listener running on a win2000 server using net8. It appears as if it it using a
It's pretty simple, actually, to change the wordsize. Check out the
Oracle8i Migration guide - specifically, page 7-38.
Brian
paquette stephane wrote:
I did not find on metalink how to upgrade and change
the wordsize from 64bit to 32bit.
Yes, I'm tired of waiting for patches that never
alter type type_name compile body;
Richard Ji
-Original Message-
Sent: Thursday, July 19, 2001 3:26 PM
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
After our ugprade to 817 from 815 and fully following all the procedures in
the manual ended up with the
Hi,
I am looking for a particular field if it exists in a database. How to
search all tables for a particular field?
Thanks in advance.
Igor
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
--
Turn the question around, and ask what are the difficulties you will
face if you *aren't* supported?
Some answers:
1) no help from Oracle Support for installation,bugs,problems,etc
2) no product media
If you don't need either of those from Oracle support, then you could
save some money.
I am looking for a particular field if it exists in a database. How to
search all tables for a particular field?
If you really mean all
select table_name
from dba_tab_columns
where column_name = 'FIELD';
Be sure that the field you are looking for is in caps.
If you mean all
Stephane,
I've had questions on migrations and upgrades in the past and the final
answer has always been: It is always safest to export/import to change what
version of Oracle your database uses. It's certainly leaves the tablespaces
a helluva lot cleaner than the other methods of migration!
Hi Igor,
Try:
Select table_name
from all_tab_columns
where column_name = 'name of column';
HTH,
-Rocky
--- igor z [EMAIL PROTECTED] wrote:
Hi,
I am looking for a particular field if it exists in a database. How to
search all tables for a particular field?
Thanks in advance.
Igor
This one's easy...look in DBA_TAB_COLUMNS.
select table_name, column_name
from dba_tab_columns
where column_name like '%WHATEVER%';
Cheers,
Mike
---
===
Michael P. Vergara | I've got a PBS mind in an MTV
If it is just a column, try selecting from DBA_TAB_COLUMNS ...
HTH
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD:
SELECT * FROM DBA_TAB_COLUMNS WHERE COLUMN_NAME = 'YOUR_COLUMN_NAME';
Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, July 19, 2001 4:01 PM
Hi,
I am looking for a
Eric,
Where you been Welcome back.
Be aware that if you do not pay for continuing support, and then you
later (years later) decide you need a suport contract again *for the
platform you started on*, Oracle has been known to retroactively
charge (at a percentage at least 50%?) for the years
select table_name, column_name
from sys.dba_tab_columns
where column_name like 'your_column_name%';
-Original Message-
Sent: Thursday, July 19, 2001 4:01 PM
To: Multiple recipients of list ORACLE-L
Hi,
I am looking for a particular field if it exists in a database. How to
search
If you don't know the name of the owner or table name and can log in as SYS or SYSTEM
or a user with DBA privileges use:
select owner, table_name from dba_tab_columns where column_name = '';
If you are just looking for that column for a particular user, login as the user and
do this
select table_name
from dba_tab_columns
where column_name = 'YourFieldName'
Is that what you are looking for?
Gene
--- igor z [EMAIL PROTECTED] wrote:
Hi,
I am looking for a particular field if it exists in
a database. How to
search all tables for a particular field?
Thanks in
Check in dba_tab_columns view. Search table_name based on known column_name
Regards,
- Kirti Deshpande
Verizon Information Services
http://www.superpages.com
-Original Message-
From: igor z [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, July 19, 2001 3:01 PM
To: Multiple
dba_tab_columns
igor z wrote:
Hi,
I am looking for a particular field if it exists in a database. How to
search all tables for a particular field?
Thanks in advance.
Igor
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dennis M. Heisler
INET: [EMAIL
Hi
Some times I am unable to connect from Application server to DB sever.What
could be problem?It is happening some times.Can you suggest what can do to
recttify this problem.I have oracle8.1.6 and OiAS.
Thanks
-Seema
_
Get your
This is when it will happen... Access usually does the and hence the
problem...
SVCTOOLcreate table test (testnum number);
Table created.
SVCTOOLselect table_name from user_tables;
TABLE_NAME
--
test
SVCTOOLdesc test
ERROR:
ORA-04043: object test does not exist
1 - 100 of 126 matches
Mail list logo