Hi Tom, I have a question regarding to add some constraint into a table. I have 2 tables defined as: create table TableA ( fieldA varchar2(10), fieldB varchar2(10), fieldC varchar2(5), fieldD varchar2(10) not null, fieldE number(38) not null, Constraint TableAPK

Hi Tom, I am trying to alter the tablespace to the transportation tablspace. First I do: alter tablespace users read only; Then do : exp sys/change_on_install file=02072001.dmp transport_tablespace=y tablespaces=users triggers=n constraints=n But I got the error as: Export: Relea...

Hi, I have read quite a bit on Oracles RMAN utility and know that for hot backups RMAN doesn't use old method of placing tablespaces in Archive log mode freezing datafile headers & writing changes to Redo/ Archive logs. Hence a company with a large DB shouldn't experience the usu...

Hi TOM, Sorry for asking this basic question (After two hours of searching, I am unable to find the answer) Let's say I have run opatch in an ora19 home to patch the binaries. But then I "forgot" to run datapatch. Is there any dictionary view to tell me that I "forgot"? BR Peter

Hi Team, I use ApEx 22.1 and SQL Developer. In an ApEx page, users have to upload 4 photos of their workstation. Then with PL/PDF I generate the PDF containing texts, photos and ID number. I have no control over the uploaded photos. The aspect ratio of the images can be 16:9 or 4...