Primary Key Constraints

Is there an easy query to get a list of tables that don't have any primary key? I've tried a couple of different ones, but none of them work quite right. Seems like this should be easy. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Sardin INET: [EMAIL PRO

Replication Manager

Has anyone used Replication Manager with success? Any feedback on issues you may have run into would be greatly appreciated. Does it come bundled with OEM or is it typically on a separate CD as a Management Pack? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike S

OEM Config Assistant

Using OEM Configuration Assistant 2.2, I tried to set up a Management Server/repository, etc. and through the gui I created a user with a password, etc. Now when I try to log into the Management Server with that username/password, I get "invalid credentials". Through sqlplus I can log into that u

LONG size -- set in database?

Is there any way to set the LONG chunk size on the database for all queries? The "set long " command works fine in SQL Plus to set the chunk size of LONG but when .NET pulls info, it doesn't work. Is there was a way to set it on the database side so that it would work regardless of how the databa

OS Authentication on Win2K

I am having problems getting OS authentication to work on a Win2K oracle server (8.1.7.1.1). All parameters are set properly (from what I can see). There cannot be a prefix so the following parameter is set as follows: os_authent_prefix = "" I need to be able to log into the server as a user iden

checkpoint not complete

I am noticing in the Alert Log that it notes quite often "Checkpoint Not Complete". What causes this? Does something need to be tuned? What parameter? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Sardin INET: [EMAIL PROTECTED] Fat City Network Services-

Trigger/character search

Is there any way to do pattern matching in a PL/SQL trigger? In other words, if I had two strings and one ended with a character (ie. "g") and one ended with a number, is there a way to search for it so that it would flag if it is only a number? -- Please see the official ORACLE-L FAQ: http://w

Changing location of control file

To change the location of a controlfile, do you simply need to change the destination directory in the init? Do you have to copy anything to a different directory? I have three controlfiles that are all on one physical drive and I want to move one of them to another physical drive. -- Please see

Full Import/tablespace sizes

To do an import from a full export of a database, do the tablespaces already need to be set up before the import? How can you query the database to get the tablespace name and the total space needed for each tablespace? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mi