| twice [message #61534] |
Tue, 04 May 2004 06:00  |
Tomasz
Messages: 13
Registered: May 2004
|
Junior Member |
|
|
Hi all
I have trouble with my oracle test instance. Each operation I do I was copied. For example when I made account test It create 2 accounts. Only accounts was doubled.
Do I something wrong?
My current DB version is 8.1.7 on RH 6.2.
cheers
|
|
|
|
| Re: twice [message #61535 is a reply to message #61534] |
Tue, 04 May 2004 07:14  |
Anatol Ciolac
Messages: 113
Registered: December 2003
|
Senior Member |
|
|
|
Explict much. What program you use? Are you created some system triggers what possible to reexecute your operations? What are you make, after whitc has appeared this problem. How you can make two accounts(you cannot make two accounts with some name).
|
|
|
|
| Re: twice [message #61544 is a reply to message #61535] |
Tue, 04 May 2004 22:20 |
Tomasz
Messages: 13
Registered: May 2004
|
Junior Member |
|
|
|
Yes two accounts, when I create user test, when I do it, (on Sql plus : create user test iden...) and I pass select username from dba_users I take two test account. This situation is same under SQL Navigator. What's going on??
|
|
|
|
| Re: twice [message #61547 is a reply to message #61544] |
Tue, 04 May 2004 23:18 |
Anatol Ciolac
Messages: 113
Registered: December 2003
|
Senior Member |
|
|
Exec this sql:select * from dba_users
where lower(username)='test'; in sqlplus and put results to forum. It is interesting problem.
|
|
|
|
| Re: twice [message #61548 is a reply to message #61535] |
Tue, 04 May 2004 23:38 |
Tomasz
Messages: 13
Registered: May 2004
|
Junior Member |
|
|
Query:
select * from dba_users where lower(username) = 'test';
Results:
USERNAME USER_ID PASSWORD ACCOUNT_STATUS LOCK_DATE EXPIRY_DA DEFAULT_TABLESPACE TEMPORARY_TABLESPACE CREATED PROFILE INITIAL_RSRC_CONSUMER_GROUP EXTERNAL_NAME
------------------------------ ---------- ------------------------------ -------------------------------- --------- --------- ------------------------------ ------------------------------ --------- ------------------------------ ------------------------------ --------------------------------------------------------------------------------
TEST 96 8ABA3EF9BB2D284D OPEN 04/07/04 SYSTEM SYSTEM 04/05/05 DEFAULT DEFAULT_CONSUMER_GROUP
TEST 96 8ABA3EF9BB2D284D OPEN 04/07/04 SYSTEM SYSTEM 04/05/05 DEFAULT DEFAULT_CONSUMER_GROUP
2 rows selected.
--
It is strage because when I pass select * from all_users it take 1 row.
|
|
|
|
| Re: twice [message #61550 is a reply to message #61548] |
Wed, 05 May 2004 00:45 |
Anatol Ciolac
Messages: 113
Registered: December 2003
|
Senior Member |
|
|
|
Try to create a simple table(for example tbl). Then make select * from dba_tables where lower(tablename) = 'tbl';, then make this select on all_tables and compare results(and put them to forum). Possible you will be needed to reexectute catproc.sql script, which creates database dictionary.
|
|
|
|
| Re: twice [message #61551 is a reply to message #61534] |
Wed, 05 May 2004 00:57 |
Tomasz
Messages: 13
Registered: May 2004
|
Junior Member |
|
|
This situation exists in dba_users, when I create table, sequence, index it wasn't doubled only when I create new user. Some guy told me about rebuilding dictionary so it is the method. He told me also about copy all database file after shutdown and rexecute scritp doing dictionary.
How to inpects dictionary?
|
|
|
|
| Re: twice [message #61554 is a reply to message #61551] |
Wed, 05 May 2004 01:57 |
Anatol Ciolac
Messages: 113
Registered: December 2003
|
Senior Member |
|
|
|
I never havent recreate a dictionary but I think that it is very risk operation. Brefore doing them I think that will be a good idea to make export of database(not full - only users or tables that you need).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
