/ as sysdba) and ran into
ORA-12540: TNS: internal limit restriction exceeded.
Where is this limit set? Is it possible to change the setting?
Here is some additional information
The application that connects to this db is java based...In the past when
we were seeing lot of 4030 errors in the alert log
Murali,
Have you checked the OS event logs like the system log? Sounds like you
have hit an OS limit. Please post the rest of the error stack that followed
the ORA-12450 as this gives more information on what is the root cause of
this failure? You can find this in the listener.log at the time
I apologise for the wrong error #...it was a typo on my partthe error #
is 12540
Here is the error stack
===
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12540: TNS:internal limit restriction exceeded
I apologise for the wrong error #...it was a typo on my partthe error
#
is 12540
Here is the error stack
===
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12540: TNS:internal limit restriction
#
is 12540
Here is the error stack
===
TNS-12500: TNS:listener failed to start a
dedicated server process
TNS-12540: TNS:internal limit restriction
exceeded
TNS-12560: TNS:protocol adapter error
TNS-00510: Internal
exception? Documentation says it maxes at
32767.
I didn't find file size limit. UTL_FILE.FOPEN also has a max_linesize that
can
be set to 32767.
Yong Huang
--- AK [EMAIL PROTECTED] wrote:
what is max filesize for utl_limit.fopen ? I am unable to past beyond
51K .
-ak
what is max filesize for utl_limit.fopen ? I am
unable to past beyond 51K .
-ak
in this email
are strictly personal. QOTD: Any clod
can have facts, having an opinion is an art !
-Original Message-From: AK
[mailto:[EMAIL PROTECTED]Sent: Tuesday, November 18, 2003 1:35
PMTo: Multiple recipients of list ORACLE-LSubject:
ut_file limit
what is max filesize
AK,
Do you get INVALID_MAXLINESIZE exception? Documentation says it maxes at 32767.
I didn't find file size limit. UTL_FILE.FOPEN also has a max_linesize that can
be set to 32767.
Yong Huang
--- AK [EMAIL PROTECTED] wrote:
what is max filesize for utl_limit.fopen ? I am unable to past beyond
We have ORACLE 9ir2 on UNIX server. Our users
normally access DB through ODBC. The tools on PC side
may be MS Access or Crystal report. When users
connect to DB through ODBC, their have lot of tables,
views will show on screen. Those tables and view
include sys and system tables like:
We have ORACLE 9ir2 on UNIX server. Our users
normally access DB through ODBC. The tools on PC
side
may be MS Access or Crystal report. When users
connect to DB through ODBC, their have lot of
tables,
views will show on screen. Those tables and view
include sys and system tables like:
PROTECTED]
Sent: Sunday, June 08, 2003 11:00 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: ??? Linux/Oracle 8.1.7 2GB file size limit ???
Just curious how you arrived at the 1900 meg number.
Why not use 2000m?
Oracle defines gigabytes in binary, not decimal as
drive
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
: ??? Linux/Oracle 8.1.7 2GB file size limit ???
Just curious how you arrived at the 1900 meg number.
Why not use 2000m?
Oracle defines gigabytes in binary, not decimal as
drive mfg's do, so 2000m would be fine.
Not a criticism, just wondering.
Jared
On Sunday 08 June 2003 09:29
starts to grow we define a new one with 200MB
etc.
Seems to work so far.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 5:40 PM
I've just been informed that there is a 2GB datafile size limit with
Oracle
with 200MB
etc.
Seems to work so far.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 5:40 PM
I've just been informed that there is a 2GB datafile size limit with
Oracle 8.1.7 on Linux... PERIOD
to work so far.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 5:40 PM
I've just been informed that there is a 2GB datafile size limit with
Oracle 8.1.7 on Linux... PERIOD. This despite
think this applied to me, but after reading the note,
I ran
their formula and found a file on one of my databases that was very
close to
the limit. Plenty happy to dodge that bullet.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message
I've just been informed that there is a 2GB datafile size limit with Oracle 8.1.7 on
Linux... PERIOD. This despite the fact that we've had files in excess of this for some
time and they work just fine. The problem occurs when the autoextend feature reaches
the 2GB threshhold. Of course, Oracle
I think it is the limitation of Linux, not Oracle.
Use LVM and don't worry about file size limit. :-)
JP
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 5:40 PM
I've just been informed that there is a 2GB datafile size
I'd say file size limit/autoextend feature has been Oracle's
dirty little secret for quite a while. For a very long period
of time there was similar 4GB 'magic' barrier on Windows, that
was allegedly fixed. Workaround for the problem was to create
datafile 1 MB larger than the 'magic' number
See my note: There is no such O/S file size limit.
We have datafiles 2GB which work just fine. The problem is with autoextending
datafiles that extend from 2GB to 2GB. It's not a Linux limitation but a limitation
imposed by Oracle's implementation on Linux. Oracle 9i on Linux doesn't have
: There is no such O/S file size limit.
We have datafiles 2GB which work just fine. The problem is with
autoextending datafiles that extend from 2GB to 2GB. It's not a Linux
limitation but a limitation imposed by Oracle's implementation on Linux.
Oracle 9i on Linux doesn't have this problem. And my peeve
-3551
Phone: 212-358-8211 x 359
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Jan Pruner
Sent: Wednesday, June 04, 2003 11:55 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: ??? Linux/Oracle 8.1.7 2GB file size limit ???
I think
Of
Jan Pruner
Sent: Wednesday, June 04, 2003 11:55 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: ??? Linux/Oracle 8.1.7 2GB file size limit ???
I think it is the limitation of Linux, not Oracle.
Use LVM and don't worry about file size limit. :-)
JP
- Original Message
with my DBA buddy Walt, Help... we're losing control and we hate giving
up 'power.' :-)
Staring out the window at the mountains in Big Sky Country,
Steve
-Original Message-
Sent: Wednesday, June 04, 2003 11:25 AM
To: Multiple recipients of list ORACLE-L
I'd say file size limit/autoextend
size limit.
We have datafiles 2GB which work just fine. The problem is with
autoextending datafiles that extend from 2GB to 2GB. It's not a Linux
limitation but a limitation imposed by Oracle's implementation on Linux.
Oracle 9i on Linux doesn't have this problem. And my peeve is that it took
OWS 4
manually to something larger than 4G?
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, June 04, 2003 1:25 PM
To: Multiple recipients of list ORACLE-L
See my note: There is no such O/S file size limit.
We have datafiles 2GB which work just fine
size limit.
We have datafiles 2GB which work just fine. The problem is with
autoextending datafiles that extend from 2GB to 2GB. It's not a Linux
limitation but a limitation imposed by Oracle's implementation on Linux.
Oracle 9i on Linux doesn't have this problem. And my peeve is that it took
OWS
Professional
-Original Message-
Sent: Wednesday, June 04, 2003 1:25 PM
To: Multiple recipients of list ORACLE-L
See my note: There is no such O/S file size limit.
We have datafiles 2GB which work just fine. The problem is with
autoextending datafiles that extend from 2GB to 2GB. It's
: There is no such O/S file size limit.
We have datafiles 2GB which work just fine. The problem is with
autoextending datafiles that extend from 2GB to 2GB. It's not a Linux
limitation but a limitation imposed by Oracle's implementation on Linux.
Oracle 9i on Linux doesn't have this problem. And my
: There is no such O/S file size limit.
We have datafiles 2GB which work just fine. The problem is with
autoextending datafiles that extend from 2GB to 2GB. It's not a Linux
limitation but a limitation imposed by Oracle's implementation on Linux.
Oracle 9i on Linux doesn't have this problem. And my peeve
Title: RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???
Upgrading was number 2?
NO way!?! I am (genuinely) surprised that it wasn't number 1 suggestion...
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
You will recognize your own path when you come upon
% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, June 04, 2003 12:25 PM
To: Multiple recipients of list ORACLE-L
See my note: There is no such O/S file size limit.
We have datafiles 2GB which work just fine. The problem is with
autoextending datafiles
To: Multiple recipients of list ORACLE-L
See my note: There is no such O/S file size limit.
We have datafiles 2GB which work just fine. The problem is with
autoextending datafiles that extend from 2GB to 2GB. It's not a Linux
limitation but a limitation imposed by Oracle's implementation on Linux.
Oracle
PROTECTED] On Behalf Of April WellsSent:
Wednesday, June 04, 2003 2:30 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: ??? Linux/Oracle 8.1.7 2GB file size limit
???
Upgrading was number 2?
NO way!?! I am (genuinely) surprised that it wasn't
number 1 suggestion...
April
the size of
the file manually to something larger than 4G?
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, June 04, 2003 1:25 PM
To: Multiple recipients of list ORACLE-L
See my note: There is no such O/S file size limit.
We have datafiles 2GB which
manually to something larger than 4G?
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, June 04, 2003 1:25 PM
To: Multiple recipients of list ORACLE-L
See my note: There is no such O/S file size limit.
We have datafiles 2GB which work just fine. The problem
Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, June 04, 2003 1:25 PM
To: Multiple recipients of list ORACLE-L
See my note: There is no such O/S file size limit.
We have datafiles 2GB which work just fine. The problem is with
autoextending datafiles
Steve
Personally I am VERY glad you mentioned this today. Since I run 64-bit
Unix, I didn't think this applied to me, but after reading the note, I ran
their formula and found a file on one of my databases that was very close to
the limit. Plenty happy to dodge that bullet.
Dennis Williams
DBA
of my databases that was very close to
the limit. Plenty happy to dodge that bullet.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, June 04, 2003 4:15 PM
To: Multiple recipients of list ORACLE-L
We are on 8.1.7.4
to
the limit. Plenty happy to dodge that bullet.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, June 04, 2003 4:15 PM
To: Multiple recipients of list ORACLE-L
We are on 8.1.7.4 and it aflicted us anyway. Maybe I'll just
by increasing the size of
the file manually to something larger than 4G?
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, June 04, 2003 1:25 PM
To: Multiple recipients of list ORACLE-L
See my note: There is no such O/S file size limit.
We have datafiles 2GB
]] On Behalf Of Miller,
Jay
Sent: Saturday, November 23, 2002 1:49 PM
To: Multiple recipients of list ORACLE-L
Subject: Do user processes apply against shmmax limit?
Hi everyone,
I was always under the impression that the only concern with shmmax
was
that
it be large enough for the SGA
quite a bit with paging/swapping.
Rich
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
On Behalf Of Miller,
Jay
Sent: Saturday, November 23, 2002 1:49 PM
To: Multiple recipients of list ORACLE-L
Subject: Do user processes apply against shmmax
limit
user processes apply against shmmax limit?
Hi everyone,
I was always under the impression that the only concern with shmmax
was
that
it be large enough for the SGA to fit into it. One of my System
Administrators has just told me that the individual user processes
(i.e.,
the PGA
On 817/aix, the end-users will have access to query
data in an ad-hoc fashion.
We want to limit the problems.
I want to limit per queries so I guess that I must
used cpu_per_call.
I'm currently testing some queries and checking
statistics CPU used when call started to see how much
a query
... and we butt headlong into another fine myth, that is that
the SGA must fit into one segment.
On Sunday 24 November 2002 15:53, Richard Ji wrote:
if that SGA + user processes shmmax the system will start swapping.
That's not true. If your SGA is bigger than shmmax, it just means
the
To: Multiple recipients of list ORACLE-L
Subject: Do user processes apply against shmmax limit?
Hi everyone,
I was always under the impression that the only concern with
shmmax was that
it be large enough for the SGA to fit into it. One of my System
Administrators has just told me that the individual
if that SGA + user processes shmmax the system will start swapping.
That's not true. If your SGA is bigger than shmmax, it just means
the SGA will be fit into multiple shared memory segments. Doesn't
necessary mean the system will start swapping. Is the scan rate
going up?
Richard
Hi everyone,
I was always under the impression that the only concern with shmmax was that
it be large enough for the SGA to fit into it. One of my System
Administrators has just told me that the individual user processes (i.e.,
the PGA since we're not using multi-threaded server) get added to the
Your Sys Admin is wrong. The SHMxxx OS parameters refer to shared memory,
not private process heap memory. On most UNIX variants, the ulimit
command is used to limit the consumption of memory for heap, stack, etc...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
is used to limit the consumption of memory for heap, stack,
etc...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, November 23, 2002 11:48 AM
Hi everyone,
I was always under the impression that the only concern with shmmax
2002 11:38, Tim Gorman wrote:
Your Sys Admin is wrong. The SHMxxx OS parameters refer to shared
memory, not private process heap memory. On most UNIX variants, the
ulimit command is used to limit the consumption of memory for heap,
stack, etc...
- Original Message -
To: Multiple
**
-Original Message-
From: Miller, Jay [mailto:[EMAIL PROTECTED]]
Sent: Saturday, November 23, 2002 10:49 AM
To: Multiple recipients of list ORACLE-L
Subject: Do user processes apply against shmmax limit?
Hi everyone,
I was always under the impression that the only concern with
shmmax
HI all
We had those messages yesterday in the listener.log
file
TNS-12500: TNS:listener failed to start a dedicated
server process
TNS-12540: TNS:internal limit restriction exceeded
TNS-12560: TNS:protocol adapter error
TNS-00510: Internal limit restriction exceeded
Also on the unix
Get more cutlery! Increase the number of processes available both
system-wide and per capita.
-Original Message-
From: paquette stephane [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 04, 2002 10:39 AM
To: Multiple recipients of list ORACLE-L
Subject: TNS-00510: Internal limit
a
dedicatedserver processTNS-12540: TNS:internal limit restriction
exceeded TNS-12560: TNS:protocol adapter error
TNS-00510: Internal limit restriction exceededAlso on the unix side, we
had a message about the OSthat can not fork a new process.This is on
8172 32bits/AIX 4.3.3 The sga is 1.7G, the server
: buffer overflow, limit of 2000 bytesORA-06512: at "SYS.DBMS_OUTPUT", line 91ORA-06512: at "SYS.DBMS_OUTPUT", line 58ORA-065!
!
12: at line 17Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
500 500
DECLARE
*ERROR at line 1:
ORA-2: ORU-10027: buffer overflow, limit of 2000 bytes
ORA-06512: at SYS.DBMS_OUTPUT, line 91
ORA-06512: at SYS.DBMS_OUTPUT, line 58
ORA-065! ! 12: at line 17
_
Do you Yahoo!?
New DSL Internet http://rd.yahoo.com/evt=1207/*http://sbc.yahoo.com
-
From: Meomeo Nguyen
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 24, 2002
12:53 PM
To: Multiple recipients of list
ORACLE-L
Subject: BUFFER OVERFLOW, LIMIT OF
2000 BYTES.
Hi All,
Below is a script to retrieve data from
BFILE column and its output.The external PDF file is around 53, 435
:
BUFFER OVERFLOW, LIMIT OF 2000 BYTES.[Scanned]
Hi All,
Below is a script to retrieve data from BFILE column and its
output.The external PDF file is around 53, 435 bytes (text and
picture altogether in one file). Anyone please have a fix for this
script. I am unable to view the content
Dear All,
When We run simple pl/sql we are getting the follwoing
error
ORA-2: ORU-10027: buffer overflow, limit of 2000
bytes.
But the fact is it is running fine in another database
Completely on different server).
I have compared the following thigs please let me know
if there is anything
29, 2002 11:38 AM
Dear All,
When We run simple pl/sql we are getting the follwoing
error
ORA-2: ORU-10027: buffer overflow, limit of 2000
bytes.
But the fact is it is running fine in another database
Completely on different server).
I have compared the following thigs please let me
-2: ORU-10027: buffer overflow, limit of 2000
bytes.
But the fact is it is running fine in another database
Completely on different server).
I have compared the following thigs please let me know
if there is anything else to check other than the
follwoing one's.
1) DB version is same on both
simple pl/sql we are getting the
follwoing
error
ORA-2: ORU-10027: buffer overflow, limit of
2000
bytes.
But the fact is it is running fine in another
database
Completely on different server).
I have compared the following thigs please let me
know
if there is anything else
the
follwoing
error
ORA-2: ORU-10027: buffer overflow, limit of
2000
bytes.
But the fact is it is running fine in another
database
Completely on different server).
I have compared the following thigs please let me
know
if there is anything else to check other
the
follwoing
error
ORA-2: ORU-10027: buffer overflow, limit
of
2000
bytes.
But the fact is it is running fine in another
database
Completely on different server).
I have compared the following thigs please let
me
know
if there is anything else to check other
-
From: Bob Metelsky [mailto:[EMAIL PROTECTED]]
Sent: 10 June 2002 23:03
To: Multiple recipients of list ORACLE-L
Subject: Limit on length of decode arguments??
Hello all
In an effort to clean up data as I'm importing, I need to pass
the bad data to decode. It seems onece I
Hello all
In an effort to clean up data as I'm importing, I need to pass
the bad data to decode. It seems onece I pass 250 chars the code fails
with
SQL*Loader-350: Syntax error at line 93.
Token longer than max allowable length of 258 chars
The articles on metalink hint on problems
Anyone seen behaviour like this before ?
rem
rem simple table
rem
SQL create table blah (i number, x clob);
Table created.
rem
rem Add a row that I construct (i=1), and then
rem insert a row from an existing table (which
rem also contains a clob)
rem
SQL declare
2r varchar2(32000) :=
Version ?
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Next Seminar - UK, April 3rd - 5th
http://www.jlcomp.demon.co.uk/seminar.html
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
It didn't reproduce on 9.0.1.2.
But then it was a simple test with just a couple
of rows in the email table.
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Next Seminar - UK, April 3rd - 5th
http://www.jlcomp.demon.co.uk/seminar.html
Host to The Co-Operative Oracle Users' FAQ
:
[EMAIL PROTECTED]Subject: RE: limit user CPU usage
om
Sent
Kevin,
You can also use Resource manager to limit the CPU usage on certain user
groups .
It's pretty cool.
HTH
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, January 15, 2002 1:42 PM
Thanks, Ron, I will try it.
Kevin Wang
Hi, Guys,
Is there some parameters or user-profile prometers
in Oracle can limit user CPU usage?
I mean, make specific user or all users use less
CPU, I has a SQL query that use 100% CPU.
I know the SQL is bad, but beforedeveloper
change it, Is there something I can do?
Any suggestion
PROTECTED]]
Sent: Tuesday, January 15, 2002
12:10 PM
To: Multiple recipients of list
ORACLE-L
Subject: limit user CPU usage
Hi,
Guys,
Is
there some parameters or user-profile prometers in Oracle can limit user
CPU usage?
I mean,
make specific user or all users use less CPU, I has a SQL query
Kevin,
You could try creating a profile with the cpu_per_call and
cpu_per_session set ta a particular value. It will limit the amount of
time in hundredths of a second to the user assigned to the profile. I
woul experiment with the values before I assigned it to a user. The
manual does not say
Thanks, Ron, I will try it.
Kevin Wang
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, January 15, 2002 11:55 AM
Kevin,
You could try creating a profile with the cpu_per_call and
cpu_per_session set ta a particular value. It will limit
I am getting these errors in my listener.log when trying to connect.
Current connections are fine, it is only new connections getting the error.
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12540: TNS:internal limit restriction exceeded
TNS-12560: TNS:protocol
EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: HELP - How can I limit what program users use to connect?
Date: Thu, 23 Aug 2001 09:42:34 -0800
I can't revoke connect permissions. I am simply looking for a way
to
preven
of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: HELP - How can I limit what program users use to connect?
Date: Wed, 22 Aug 2001 13:16:03 -0800
One thing you can try
TOAD includes a module name... so select from v$session where module =
'T.O.A.D.'
It will give you a list of users... and you
lt;[EMAIL PROTECTED]>
Subject: HELP - How can I limit what program users use to connect?
Date: Wed, 22 Aug 2001 08:16:18 -0800
List,
Does anyone know of a method by which I can prohibit users from
connecting
into my Oracle 8.0.6.0.0 database by any product other than the
application's ex
[EMAIL PROTECTED]
Subject: Re: HELP - How can I limit what program users use to connect?
Date: Thu, 23 Aug 2001 09:20:15 -0800
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
Hi Ken,
Try revoking
PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: HELP - How can I limit what program users use to connect?
Date: Thu, 23 Aug 2001 09:20:15 -0800
_
Get your FREE download of MSN
List,
Does anyone know of a method by which I can prohibit users from connecting
into my Oracle 8.0.6.0.0 database by any product other than the
application's executable program? (i.e. - I don't want anyone connecting
through TOAD, etc.) But, I do want to allow anyone with DBA role to be
I don't think you can do it in 8.0.6.
Starting with 8.1.5 you could use db logon triggers.
Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, August 22, 2001 12:16 PM
You can use a password protected role which is only enabled
in the executable using a stored package that executes
dbms_session.set_role.
The package checks which program name invoked it be querying
v$session.program.
If the role is not enabled, users not granted the role do not have access
to
Hi Ken,
AFAIR you can limit connections via SQL*+ not sure though
it'll work for TOAD and other 3d party products.
Try to find pubbl.sql(?) (sorry don't remember the exact name).
It's one of the standart scripts you're supposed to run while
db creation. It creates a couple of profile tables
Title: RE: HELP - How can I limit what program users use to connect?
One thing you can try
TOAD includes a module name... so select from v$session where module = 'T.O.A.D.'
It will give you a list of users... and you could probably create a DBMS_JOB to go around and kill any user
Hi List,
I need to transport few tables from one instance to
another and of course found the sqlldr method much faster than the exp/imp.
But the problems is for large tables .When I spool
such input tables to a flat file , it stops spooling into it afterabout
2 Gb.Any possible solutions
Thnaks Joe,
Yes that was what I did as a work-around yesterday and I had
to be around for a long time on a week-end. I have most of these processes
automated and it works fine with 95% of the tables . Doing this for about 600
tables. So this would mean going back to change code again. Was
how about this:
(avg_row_size +delimiters)* number_of_rows = total
bytes.
total bytes / 19 = number of pieces.
number_of_rows / number_of_pieces = number of rows per
piece
select number of rows needed multiple times, spooling each one
individually.
then sqlldr all the pieces.
If the unix machine also has a
2 gig limit, then:
1) mknod pipe.lst
p
2) split -b 1073741824 pipe.lst
mybigfile_
3) sqlplus u/p
spool
pipe.lst
@my_commands.lst
spool off
exit
4) rm
pipe.lst
These
examples should give you enough to work with.
-Original
Message-From: JOE
I would have fed the spooled output (flat file) into a named pipe
set its output thru split.
This is similar to what I do with exports for tables that are larger
than 2GB.
Original Message
Subject:
Re: 2 Gb file limit problem
Date:
Mon, 30 Jul 2001 12:00:32 -0800
Dear list members,
Due to the fact that I am once again employed, I find that I no longer
have time to read every message on Oracle-L.
In fact, I don't have time at the moment to read most of them.
So when I go home, and cozy up to the computer for a read of
what's going on in Oracle-L, I
This is scary stuff... not to mention the fact that
it's going to cost me a fortune to rent a car ;)
http://news.cnet.com/news/0-1006-200-6333149.html?tag=3Ddd.ne.dht.=
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
I sure as heck won't be renting from Acme!
-Original Message-
Sent: Thursday, June 21, 2001 10:27 AM
To: Multiple recipients of list ORACLE-L
This is scary stuff... not to mention the fact that
it's going to cost me a fortune to rent a car ;)
21, 2001 9:27 AM
To: Multiple recipients of list ORACLE-L
Subject: Completely OT: Rental-car firm exceeding the privacy limit?
This is scary stuff... not to mention the fact that
it's going to cost me a fortune to rent a car ;)
http://news.cnet.com/news/0-1006-200-6333149.html?tag
21, 2001 9:27 AM
To: Multiple recipients of list ORACLE-L
Subject: Completely OT: Rental-car firm exceeding the privacy limit?
This is scary stuff... not to mention the fact that
it's going to cost me a fortune to rent a car ;)
http://news.cnet.com/news/0-1006-200-6333149.html?tag
1 - 100 of 115 matches
Mail list logo