0
votes
1answer
18 views

Script for listing tables having no primary key oracle 9i

I'm looking for a script to find tables within my database that have no primary key.
0
votes
1answer
34 views

num_rows in dba_tables not reflecting the real number of rows in tables Oracle 9i

I'm querying dba_tables in order to get a listing of tables and their rowcount with following sql request : select * from dba_tables where owner='dbSID'; But I notice that even for some non empty ...
0
votes
2answers
48 views

inconsistent type after querying search_condition column in all_constraints table Oracle

I'm trying to get the not null constraints in my tables, so I'm using the following sql request : select * from all_constraints where owner='userx' and constraint_type='C' and ...
0
votes
1answer
24 views

equivalent of oracle sql administration query in SQL Server 2008

I'm new to SQL Server administration, and I would like to get the equivalent of this Oracle 9i administration query : select object_type,count(*) as number from all_objects where owner='ownerSID' ...
0
votes
1answer
428 views

ORA-00933: SQL command not properly ended

I have created a database link to a remote database, MIGRERDOSSIER.US.ORACLE.COM, then I use it to insert records in a table in a local database. Here is the request I am trying to execute: insert ...
-1
votes
1answer
209 views

Inserting dates before year 1950 in Oracle

How can I insert date which is before 1950? update up_sif.tb_person set dateB =to_date('18.10.1949','DD.MM.YYYY') where ID = '123345'; It keeps update with date 18.19.2049. Any ideas?
0
votes
3answers
1k views

ORA-00905: missing keyword when trying to create a synonym

I have a problem when I try to create a synonym like this: CREATE SYNONYM B2H.BILLING_USER_ACTIVITY@PACOMNET FOR B2H.BILLING_USER_ACTIVITY@PACOMNET.US.ORACLE.COM; Why does this happen and how can ...