CREATE TABLE “CRPDTA”.”F00165T” (“GDOBNM” CHAR(10 BYTE), “GDTXKY” VARCHAR2(254 BYTE), “GDLNGP” CHAR(2 BYTE), “GDTXPO ” VARCHAR2(254 BYTE), “GDCRTU” CHAR(10 BYTE), “GDDQE” NUMBER(6,0), “GDTENT” NUMBER, “GDMUSE” CHAR(10 BYTE), “GDUPMJ” NUMBER(6,0), “GDTDAY” NUMBER,…
SQL> show user USER is “TOM” SQL> select * from zam; ID JMENO HIST_DATE ———- ———- ——— 1 Tom 2 Matej SQL> select dbms_flashback.get_system_change_number from dual; GET_SYSTEM_CHANGE_NUMBER ———————— 2077404 SQL>…
Tabulka SQL> connect tom/oracle_4U Connected. SQL> create table zamestnanci (id integer primary key, jmeno varchar2(10)); Table created. [oel64:oracle:orcl12c]$ cat zamestnanci.dat 1, Tom 2, Matej 3, Tomik 4, Jaroslava 5, Pepa…
SQL> show con_name CON_NAME —————————— CDB$ROOT SQL> create user test identified by test; create user test identified by test * ERROR at line 1: ORA-65096: invalid common user or role…
Chyba SQL> ALTER DATABASE DATAFILE ‘/oradata/PROD/PROD/undotbs01.dbf’ RESIZE 5000M; ALTER DATABASE DATAFILE ‘/oradata/PROD/PROD/undotbs01.dbf’ RESIZE 5000M * ERROR at line 1: ORA-03297: file contains used data beyond requested RESIZE value Řešení SQL>…
RMAN-06207: WARNING: 16 objects could not be deleted for DISK channel(s) due RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status RMAN-06210: List of Mismatched objects RMAN> crosscheck backup;…
Smazání db console C:\Users\tomas.solar>emca -deconfig dbcontrol db -repos drop Znovu vytvoření C:\Users\tomas.solar>emca -config dbcontrol db -repos create -SID ORCL -PORT 1521 -ORACLE_HOME c:\oracle\product\11.2.0\dbhome_1\ Destination (shared install) : c:\oracle\product\11.2.0\dbhome_1\\tomas-solar.com_ORCL DeployMode :…
Kontrola prefixu SQL> show parameter authent NAME TYPE VALUE ———————————— ———– —————————— os_authent_prefix string ops$ remote_os_authent boolean FALSE OS user [root@oel64 ~]# useradd hacker [root@oel64 ~]# passwd hacker Changing password…
