Oracle FAQS and TIPS

zhaozj2021-02-12  139

Add primary key1 on the established table. Create index create index test_idx on test (id); 2. Add Constrained ALTER TABLE TESTADD CONSTRAINT TEST_PK PRIMARY Key (ID) USING INDEX TEST_IDX;

The following error occurs when there is an error, the following error: Credential Retrieval Failed solution: Modify SQLNET.AUTHENTICES = (NTS) is not annotated if SQLNET.AUTHENTICATION_SERVICES = (NTS) is not commented, then comment out # SQLNET.AUTHENTICATION_SERVICES = (NTS) Comment

ALTER system set events = '10231 Trace Name Context Forever, Level 10'; Internal event, setting the damaged data block when you are scheduled to scan.

View TableSpace Space Usage Select A.TablesPACE_NAME, TRUNC (SUM (B.Bytes / 1024/1024), 2) "Free (M)", Trunc (SUM (A.BYTES / 1024/1024) -Sum (b. BYTES / 1024/1024, 2) "Used (M)", Trunc (SUM (A.BYTES / 1024/1024), 2) "All (m)", Trunc (SUM (B.BYTES / 1024/1024) /sum (a.bytes/1024/1024), 2) *100||'% '"free (%)" from dba_data_files ajoin dba_free_space b on (a.file_id = b.file_id) group by a.tablespace_name; how to specify TNSNAME.ORA location Set Environment Variable TNS_ADMIN

Get the current SCN (9i) SELECT DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER from DUAL

转载请注明原文地址:https://www.9cbs.com/read-6671.html

New Post(0)