I checked it.
The problem is that he has chr(10) (newline) in his data so the output is
truncated.
Using select replace(field,chr(10),'') instead of select field make the
problem go away.
BTW - I also tested doing the replace on numeric fields and it comes out ok.
No need to check if the field
I think that you have to recheck the metalink doc that says that processes
should not be more then v$license. lets say that your application opens 3
concurrent connections to the database. You buy 100 users license and can
activate only 33 because your max processes is 100. Does not seem right to
Oracle has very good reason to have this role
limitation.
Suppose you have a role role_a. Through this role you have access to a
table table_b. Now you create a procedure that accesses table_b. An assume that
your privileges are valid through role only.
And some wise guy/gal comes in and
Raj,
Revoking a role on just a whim is a very dangerous
thing and I think that could be a costly mistake for the wiseguy. This role
could be used in places other than stored procedures as well.I consider
revoking a role and revoking an explicit privilege the same level of mischief
and
Kevin, i think thats exactly what we're going to end up doing.
thanks for the verification.
joe
Kevin Lange wrote:
How about running a script just before the backup that
1) Reads the current log number.
2) Forces a log switch.
3) Copies the logs to a seperate directory.
4) Backups up
ASS Management, makes me think of that server I used to work on at the EPA,
DBA to UNIX SA: Did you back Uranus?
UNIX SA to DBA: Yep Uranus was backed up last night.
bwahahahaha
joe
Koivu, Lisa wrote:
ASS Management? I'm snickering, I know it's juvenile humor, but...
LOL! Let me tell
Thanx Guys.
I used a combination of repalce/translate to remove the unwanted
characters.it worked out.
thanx everybody.
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: oraora oraora
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
Dear all DBAs,
Is there any way to remove the lock of table which
status is already marked as "killed"?
No matter how many times i try to kill the session,
it still marked as "killed",
but it still won't release the lock.
Thanks in advance.
Nope, there is no bitmap index
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, December 24, 2002 3:48 PM
Bitmap indexes?
joe
Shaleen wrote:
Jonathan,
What do you make out of following deadlock graph. This is happenning when
2
All,
In our 8.1.7.4 warehouse, we are attempting to copy records from a
partitioned table in one domain to a partitioned table in another
domain (via a database link) like so:
alter session enable parallel dml;
insert /*+ append parallel(a,12) */ into tablea a
select /*+ full(b)
Hi All,
I have installed Oracle 8.1.7 on Win 2000 server. I am able to
connect
to the server from a Oracle client installed on Win 2K professional but
cannot connect
to the server from Oracle client's installed on Win 98, 95. I have tried
this connection
from more than one Win 98, 95
shuan.tay\(PCI¾G¸R³Ô\),
Hi, It is because oracle will have to wake up pmon to rollback those
uncommitted transactions, so, the lock cannot be released befor the rollback complete.
You have to wake. Some trick said in this list is that you use
oradebug to wake up
Is it because it was sorting on the partition key to enable each parallel DML
worker take care of a particular partition? when u serialized the
transaction, it didn't have to sort because there was only one particular
worker associated with the insert.
Just a guess.
Regards
Naveen
-Original
Dear all DBAs,
What is this error suppose to mean?
$oerr ora 07445
Cause: An OS exception occurred which should
result in the creation of a core file.
This
is an internal error.
Action: Contact your customer support
representative.
and
$oerr ora 1242
Cause: The database is in NOARCHIVELOG
This means the transaction issued by the session is
still rolling back. The session is not killed completely or the table locks
removed till the transaction completely rolls back.
So how do you know when it's going to be over? Just
issue the following query
SELECT USED_UBLK
FROM
chao_ping,
where to find the oradebug? is it a command?
what should i do to run the oradebug?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, December 26, 2002 1:33 PM
shuan.tay\(PCI¾G¸R³Ô\),
Hi, It is because oracle will have to wake up
You don't mention the version of database.
It's not completely unheard of for a killed session holding
a lock to require a database bounce to release the lock, as
there are (unreproducable) cases of PMON never cleaning
up a session that was killed while holding a lock.
I've seen it happen a
Shaleen,
This is done to preserve security.
User A owns a table MY_TABLE.
Role A_STUFF allows insert, select, update, delete on A.MY_TABLE.
grant insert,select,update,delete on MY_TABLE to A_STUFF;
( note that the role was not granted admin privs on the table )
User B is granted role
Joe,
Did you read my earlier post on using bparchive/bpbackup commands
and the bpend_notify script?
I hate to tell you to RTFM, but ... ;)
Jared
On Wednesday 25 December 2002 17:18, Joe Testa wrote:
Kevin, i think thats exactly what we're going to end up doing.
thanks for the
If you're using tnsnames.ora to connect to the database, make sure the
tnsnames.ora file on the client matches the listener.ora file on the server.
Also check the sqlnet.ora file to make sure tnsnames is specified first.
Also, after you verified that, do a tnsping to the target instance from
21 matches
Mail list logo