Oh yea, and You are the only one knowing all the passwords :-)
Rachel Carmichael [EMAIL PROTECTED]
There should be at leat 2 DBAs -- what if you get sick or (as one of
my bosses used to say) what if you get hit by a truck?
Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
As well as in MySQL
There is no need for such table in SQL Server.
If you need, you do just:
select 'whatever'
without from clause.
Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
Look into
http://www.itsystems.lv/gints/dba_selects.htm#s21
It seems exactly what You need
Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/
user/all/dba_constraints should be enough
Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/
Abdul
Oh, I get such mails usually once a month, although they are from persons
of Nigeria.
If these are from yahoo or so then I send them back to [EMAIL PROTECTED]
else just press del
Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/
User's home directory (better special subdirectory - only for those
scripts) should be registered in the config file of webserver as a
directory where cgi scripts are running.
For example if You look in the Apache config file You will find such info
along with my examples
# ScriptAlias:
I sent such code some 2-3 months ago to this list, cannot find it quickly
now. That used autonomous transactions and stored errors in a table. I'm
not posting much, therefore You may search in archives using my name ...
Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
Oh You may consider all these event triggers on create, on drop etc.
Capture the previous code from data dictionary and store it in some table
This is just an idea, not implemented procedure at least by me
Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/
I'm trying to collect some links of resources that compares various
databases
Here is the result until today
http://www.itsystems.lv/gints/compare_db.htm
You all are welcomed to send more!
Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/
searching in google for
script compare two schemas oracle
gives as the 6th result
http://www.arrowsent.com/oratip/tip15.htm
that may be sufficient in your case
Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/
Working with FM
Oracle8i Master Index: D
press on DI
Looking for dirty buffers
found link dirty buffer (Concepts)
and here is an excerpt:
The buffers in the cache are organized in two lists: the write list and the
least recently used (LRU) list. The write list holds dirty buffers, which
That depends on mobile phone service provider, I think
We all have e-mail addresses in form [EMAIL PROTECTED], where
xxx is our number. By default they are closed and if we would like to
get e-mails then we have to send special sms to special service number to
enable this feature.
And
I remember once a designer package compiled forever, it just hang up ...
I looked in the previous release of Designer and found that the code has
been changed although the meaning was really the same. So I took some 5-10
lines from previous version and voila! - it worked. Later this was
Sun Certified Programmer Practice Exam
http://www.geocities.com/SiliconValley/Orchard/9362/java/javacert/newboone1-19.html
http://www.geocities.com/SiliconValley/Orchard/9362/java/javacert/newboone20-39.html
http://www.geocities.com/SiliconValley/Orchard/9362/java/javacert/newboone40-70.html
I deleted the original mail, but You can find this topic in
Oracle8i SQL Reference
Release 3 (8.1.7)
Part Number A85397-01
SQL statement GRANT
look under section syntax
grant_object_privileges_clause image
Although there is a note
column
Specify the table or view column on which privileges
By default MySQL has no transactions
You have to add special component to access transactional safe tables
called Berkeley db tables. You can commit and rollback on only these
tables. For others every wrong (not syntactically, but for example
inserting characters into number column) insert and
Thanks for clarification, all my knowledge about transactional tables are
from MySQL docs.
I'v used only not transactional safe tables for some web projects.
Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/
Some selects You can find in
http://www.itsystems.lv/gints/dba_selects.htm
I'm sure there are websites with more scripts around the net, of course...
Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/
How do I check who is currently logging into database, where
You have messed up quotes in IF condition
Maybe You can use some coding style other than chaotic?
It helps in debugging, believe me.
Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/
File login.sql in %Oracle_home%\DBS\
Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/
Simply as Catherine alraedy said formatting gives extra space. It takes one
more byte in variable Emp_Bar_Code VARCHAR2(15) and this variable is too
short
Just look at example
SQL select length(
2 TO_CHAR( 12345, '099' ) ||
3 TO_CHAR( SysDate, 'MMDD' )
4 )
5 from dual;
It isn't an elegant solution but You can just look into source
Something like
SELECT
owner
,type
,name
FROM all_source
WHERE line = 1
AND upper(text) like '%WRAPPED%'
ORDER BY
owner
,type
,name;
Gints Plivna
IT Sistçmas, Meríeïa 13,
I sent this e-mail to a friend who works with SqlServer and he sent this to
a SqlServer list as You can see from headers
Here are comments of a member :-
Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/
- Original Message -
To: SQL 7
You should read at least Oracle concepts manual
a. How to login into Oracle thru sqlplus
-how to know login and passwd?
http://www.itsystems.lv/gints/def_usr_paswd.htm
b. How to see what are the Databases already created.
Hmm, I think You mean schema/user in Oracle language
SELECT
I also have sometimes this weird situation
I usually set buffer width 1000
and linesize also 1000
Sometimes I cannot use scrollbar to the right but the cure for that is
simple
if I change the dimensions of my SQL/Plus window then all is just fine
Not too often, but anyway
I don't know
i forgot to mention that i did look in to manual
This soon will be the right style write it :-
I really not expert in sqlloader but I can say what I would do in such a
situation
I would create a temporary table and load all data (of course remebering
the order) there without any
Username: OUTLN
Password: outln
Created: when installing Oracle8i
Description: (From Oracle8i Migration Release 3 (8.1.7)) Oracle8i adds the
OUTLN user schema to support Plan Stability. The OUTLN user acts as a place
to centrally manage metadata associated with stored outlines.
This user has DBA
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=18870.1
explains that rather well
Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/
- pick out the name of the procedure thatis currently running,
check http://osi.oracle.com/~tkyte/who_called_me/index.html,
dbms_utility.get_call_stack, dbms_utility.get_error_stack
-pick out the start_time of the procedure
discussed some days ago
- pick outthe end_time of the procedure when it
Just a note
Inserting in an error table in the excpetion clause is a common problem
because
if something goes wrong and exception was thrown then You usually don't
want commit
But You cannot insert ereror record without commit
So in ancient times there was dbms_pipe etc. Since 8.something You
You have to declare this variable in package1 specification
create or replace package pkg1 is
v_var VARCHAR2(10) := 'Blahblah';
end;
/
create or replace package pkg2 is
procedure showvar;
end;
/
create or replace package pkg2 body is
procedure showvar
begin
If you run procedure from SQLPlus then you can use option set time (or
timing, didn't remember) on and simply count the difference
If you need this info inside the procedure
then just simply in the fisrt line of procedure remember the start time in
some variable either from sysdate or
Case*Method Entity Relationship Modelling by Richard Barker; 1990; ISBN
0-201-41696-4;
Data Model Patterns / Conventions of Thought/ David C. Hay
The Data Model Resource Book by L. Silverston, W.H.Inmon, K. Graziano;
1997; ISBN 0471-15364-8;
Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
It seems that raise in on_logon trigger is equivalent to logoff or maybe
NOT logon :-)
so here is scenario
1.
I tried to connect with gints/passwd@tuk
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
With the Partitioning option
JServer Release 8.1.7.0.1 - Production
Although there are already so many responses I would like to add one more
You can of course put all logic in one trigger and then have control over
events
Sometimes it is impossible in the trigger because there is limitation of
trigger size (32 K)
So in that case You have to put logic in
Raeson is implicit data type conversion
ie. explicit conversion is when you use to_number, to_char etc
implicit is when Oracle silently does the same
more
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/a76939/adg04typ.htm#418827
Gints Plivna
IT Sistçmas, Meríeïa
Hi!
Unfortunately or maybe fortunately :-)? this is a problem of my friend, no
my own, so I don't know more details, at least now.
It is following:
There are two servers running Oracle Financials production and test, they
both produces reports in pdf format. And the problem is that test
select * from dba_role_privs where granted_role = 'DBA';
Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/
I don't know
But You can get last_number from dba/user_sequences view
I just looked at this view and found some interesting results
If sequence is nocache then it seems last_number really is the last
number
But if some sequence values are stored in cache then last number values are
something
NT 4.0 SP 6 with both IE 5.5 SP 1 and Netscape 4.73
Working...
Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/
Boivin,
To make such things you need dynamic SQL either execute immediate
(8.1.something and above) or dbms_sql (more clumsy)
Here is example using execute immediate
qaqa is table of one column col1, max (col1) = 17
qaqa_seq is sequence
gints@ create table qaqa (col1 number);
Table created.
gints@
Hi!
Maybe You can help me:
One can call a cmd or bat file with parameters like
example.cmd para parb parc
and in this cmd file I can refer to them using %1 %2 %3 and so on
My problem is following
How can I get more than 9 parameters because when I use %10 in cmd file I
get first passed
As nobody gave me the script I really wanted to, I had to create one myself
:(((
Starting part is based on Jared's dump.sql but the rest of course is
different.
Here is link to it, just in case of need ;)))
http://www.itsystems.lv/gints/dba_selects.htm#s21
Gints Plivna
IT Sistçmas, Meríeïa 13,
INSERT INTO target_table (target_column)
SELECT decode(source_column, '?', 98, 'X', NULL, source_column)
FROM source_table;
1. This isn't pl/sql, just pure insert statement
2. If datatype of target_column is Number You cannot insert 'Missing info'
in this column, use NULLs instead
3. If You
'98'!' contains too many quotes
Just a question:
Do you try a little bit to find error reasons yourself or just write an
email on the spot? ;)
Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/
Just in case
Do You have added correctly entries in utl_file_dir?
If I remeber correctly there was a difference between Unix and NT. On one
You need to put slash on the end, on another not.
Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/
http://www.itsystems.lv/gints/oracle_limits.htm
Second row from the beginning ;)
Although You will face hardware limitations much sooner
And remember about licensing ;)
Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/
Maybe You could find useful such approach:
where_clause = '';
comma = ' WHERE ';
LOOP
where_clause = comma || new_condition;
comma = ' AND ';
END LOOP;
So in this case You don't need always WHERE in your select especially such
interesting construction like 1=1
BUT as always IT DEPENDS...
above 8.something
alter table table_name move tablespace tablespace_name;
Or always you can
1. export table
2. recreate in another tablespace
3. import data in table created in step 2.
Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/
Just do explain plan for this and look...
It seems it isn't so simple ;)
Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/
Your second step
2)alter user scott default tablespace tools,(before it's users)
isn't that I explained in previous mail.
In this case You have to
1) drop emp table
2) either alter user scott with another default tablespace or specify
another tablespace in create table clause
3) create emp
Maybe turn them to something like in Hirosima?
Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/
Rachel
You will find this and other Oracle limitations here
http://www.itsystems.lv/gints/oracle_limits.htm
Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/
I hope all list members are OK!
I hope everybody thinking and laughing of something like that all around
the world sees the results!
I hope this isn't the start of 3rd World War!
And don't be afraid of that and don't panic because this is exactly what
terorists want. Of course, I know, it is
I accidently did it some 3 or 4 years ago, received these mails some 2
years as valuable excite customer but after 2 years of my absolute
ignorance they have stopped sending.
Just put it all in trash bin ;)
ESPECIALLY with EXCITE. my kids sign up for stuff all the time, and I am
NEVER able to
Although there is European Basketball Championship in Turkey and I'm a big
fan of it, I don't know Turkic (I suppose so) now ;)))
Gints Plivna
IT Sist?mas, Mer?e?a 13, LV1050 R?ga
http://www.itsystems.lv/gints/
You have to directly grant privilege CREATE TABLE to this DL user
Not via role
Dynamic SQL counts only directly granted privileges
Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/
Hi!
It seems it is explained here
http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/a76939/adg10pck.htm#6142
excerpt:
PL/SQL lets you overload packaged (but not stand-alone) functions. You can
use the same name for different functions if their formal parameters
Should be okay if you you use it only for plsql variables, which Oracle
version do you have?
Maximum size of a varchar2 plsql variable is 32000
Maximum size of a varchar2 column in a table is 4000 bytes
see more about variable sizes in
http://www.itsystems.lv/gints/oracle_limits.htm
Gints
look in application developers guide or plsql user's guide for more info
I've succesfully created for testing purposes them as follows
create or replace trigger ON_ALTER
AFTER ALTER ON DATABASE
BEGIN
INSERT INTO sys_aud_table (
event
,id
,timestamp
,login_user
You cannot create ER diagram of a schema, you can create only server(data)
model diagram
If you want to create this diagram yourself, ie on paper, using some
graphic tool like M$Word, Corel or M$Paint then you will need to use at
least such data dictionary views like
{all/dba/user}_tables
Maybe you can simply call procedure with autonomous transaction in system
trigger
Is it possible?
Gints Plivna
[EMAIL PROTECTED]
Yea and it can reverse engineer not only oracle, but for example mysql
database too.
Designer cannot because it has too strict rules for column types.
Gints Plivna
I'm not an expert in this area but I do know that we haven't two apaches
ie. our administrator installed Oracle and IAS and then added PHP module
and this WASN'T very painful process ;)
How? I don't know :(
Oracle 8.1.7 on red hat linux 6.2
Gints Plivna
select sysdate - 1 from dual;
Gints Plivna
John Dunn
use procedure dbms_lock.sleep
Gints Plivna
John Dunn
I would like to recommend to read some book about the very concepts,
I don't think there are many changes from these times in process
management, memory management, file system management and i/o management
for example
A.Silbuschatz, J.Peterson, P.Galvin Operating Systems Concepts Addison
Wesley
You can find a little bit how it is in our organization
http://www.itsystems.lv/gints/eng/naming_conventions.htm
Gints Plivna
Tracy
There are some limitations regarding size of procedures
You can find this info in
http://www.itsystems.lv/gints/oracle_limits.htm
Gints Plivna
You should call it using parameters at the very end
For example my remote procedure is:
create or replace procedure qaqa (in_bzz IN varchar2 default 'bzzz') is
begin
insert into qaqa1 values (in_bzz);
commit;
end;
/
On current server execute such statements:
SQL exec qaqa@repsislink
PL/SQL
Ho, ho, now I'm well prepared!
I created an e-mail template with all subscribe statements needed for all
fatcity lists I'm interested in.
It will be like an event trigger on_bounce ;)
I only hope that I will be bounced from all lists hosted in fatcity or the
second alternative - I cannot
Wow, I'v always been thinking that Oracle docs are rather good including
Designer. And I found them that.
You need at least two steps
1. In design editor generate-capture design of-server model-fill in
appropriate fields
2. In repository object navigator utilities-table to entity rettrofit-
and
Hi!
I've removed all papers, You can test it ;)
I do agree that it maybe is a sort of crime, but if You have read about
Open Source, then You know their world outlook about how to get known in
the Internet world. I think this is one of the reasons many people don't
like M$ and like Linux. Ok,
Yeah, another one ;)
Before several months already somebody in this list faced this problem ;)
If there is an error in a LOGON Trigger, nobody (not even SYS) may connect
to the database. Connect with INTERNAL and drop the trigger may help in
this situation.
Gints Plivna
If it is an unique index that enforces unique constraint you cannot simply
drop it
You have to drop unique constraint
alter table tablename drop constraint constraintname;
an example follows
SQL desc qaqa1
NameNull?Type
---
Just testing, not understanding why I was bounced ;)
--
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 access / Mailing Lists
Hi!
How it is in our case
http://www.itsystems.lv/gints/eng/naming_conventions.htm
But this was not mentioned earlier because I created it some minutes ago ;)
Gints Plivna
COLUMN address NOPRINT
COLUMN username FORMAT a12
BREAK ON address SKIP 1
SELECT
a.address
,sql_text
,osuser
,username
FROM
v$sqltext a
,v$session s
WHERE s.SQL_ADDRESS = a.ADDRESS
AND s.status = 'ACTIVE'
AND s.type
Hi!
I don't remember the original place but here is one. You may want to adapt
it to Your needs.
Gints Plivna
undef prex
undef prefx
undef a
undef thisuser
undef b
undef REMOTESCHEMA
undef REMOTEPASSW
undef connstring
undef c
undef todaysdate
variable prefx varchar2(3)
declare
i number ;
j
Hi!
Give this list address and other links such as technet where to find info.
Gints Plivna
"andrey"
Hi!
In case You have free time or like object oriented modelling, class
diagrams and oracle You may explore such a link:
http://www.itsystems.lv/gints/files/oracle/oracle_s.htm
All suggestions and errors are welcome!
Gints Plivna
--
Please see the official ORACLE-L FAQ:
Yea, to see it on a clint's SQL*Plus You have to modify
\Hkey_local_machine\software\oracle\NLS_DATE_FORMAT
At least this is on NT, I don't know about 95, 98
Gints Plivna
I don't know the limit of columns making PK.
But I can suggest to use surrogate key and populate it from sequence.
What You will do with your 6 columns if you need a foreign key to this
table?
Gints Plivna
You can get this from source or install scripts.
Gints
procedure analyze_schema(schema varchar2, method varchar2,
estimate_rows number default null,
estimate_percent number default null, method_opt varchar2 default
null);
-- Analyze all the tables, clusters and indexes in a schema.
We have strict algorithm for table columns, keys, sequences and indexes
1. All tables have 3 cahracter long aliases
So all columns are in form alias_colname for example emp_id, emp_name,
emp_adr_id, adr_street_name
2. All tables have surrogate primary key column in form alias_id
3. All primary
85 matches
Mail list logo
