SELECT owner, segment_type, tablespace_name , count(*) FROM dba_segments GROUP BY owner, segment_type, tablespace_name ORDER BT ownerche mi ha dato evidenza di dove gli oggetti dei vari utenti erano.
CREATE TABLESPACE <TBS_NAME> DATAFILE '<DBF_FILENAME>' SIZE <SIZE>
EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
CREATE TEMPORARY TABLESPACE <TEMP_TBS_NAME> TEMPFILE '<TEMP_DBF_FILENAME>' SIZE <SIZE>
REUSE;
ALTER TABLESPACE <TBS_NAME> ADD DATAFILE '<DBF_FILENAME>' SIZE <SIZE>;
ALTER DATABASE DATAFILE '<DBF_FILENAME>' RESIZE <NEW_SIZE>;
CREATE USER <USER> IDENTIFIED BY <PASSWORD>
DEFAULT TABLESPACE <TBS_NAME>
TEMPORARY TABLESPACE<TEMP_TBS_NAME>;
GRANT <GRANT1>, <GRANT2>, <GRANT3>, <GRANTN> TO <USER>;
Database log mode No Archive ModeAutomatic archival DisabledArchive destination /u02/app/oracle/oradata/orcl/archOldest online log sequence 26Current log sequence 28
Database log mode Archive ModeAutomatic archival EnabledArchive destination /u02/app/oracle/oradata/orcl/archOldest online log sequence 26Next log sequence to archive 28Current log sequence 28CREATE TABLE PORTS( PORT_ID NUMBER, PORT_NAME VARCHAR2(40) NOT NULL );
ALTER TABLE PORTS MODIFY PORT_NAME NOT NULL;
CREATE TABLE PORTS( PORT_ID NUMBER, PORT_NAME VARCHAR2(40) CONSTRINT PORTS_NN NOT NULL );
ALTER TABLE PORTS MODIFY PORT_NAME CONSTRINT PORTS_NN NOT NULL
CREATE TABLE VENDORS( VENDOR_ID NUMBER PRIMARY KEY, VENDOR_NAME VARCHAR2(30), STATUS NUMBER(1) CONSTRAINT VENDORS_CHECK CHECK (STATUS IN (4,5)), CATEGORY VARCHAR2(5) );I vincoli di PRIMARY KEY, FOREIGN KEY, CHECK e UNIQUE possono essere definiti anche in "out line":
CREATE TABLE PORTS( PORT_ID NUMBER, PORT_NAME VARCHAR2(40), CONSTRAINT PORTS_PK PRIMARY KEY (PORT_ID) );
ALTER TABLE PORTS ADD CONSTRAINT PORTS_PK PRIMARY KEY (PORT_ID);
ALTER DATABASE DATAFILE '<path_to_datafile>' RESIZE <size>;
SET PAUSE ON SET PAUSE 'Press Return to Continue' SET PAGESIZE 60 SET LINESIZE 300 COLUMN "Tablespace Name" FORMAT A20 COLUMN "File Name" FORMAT A80 SELECT Substr(df.tablespace_name,1,20) "Tablespace Name", Substr(df.file_name,1,80) "File Name", Round(df.bytes/1024/1024,0) "Size (M)", decode(e.used_bytes,NULL,0,Round(e.used_bytes/1024/1024,0)) "Used (M)", decode(f.free_bytes,NULL,0,Round(f.free_bytes/1024/1024,0)) "Free (M)", decode(e.used_bytes,NULL,0,Round((e.used_bytes/df.bytes)*100,0)) "% Used" FROM DBA_DATA_FILES DF, (SELECT file_id, sum(bytes) used_bytes FROM dba_extents GROUP by file_id) E, (SELECT Max(bytes) free_bytes, file_id FROM dba_free_space GROUP BY file_id) f WHERE e.file_id (+) = df.file_id AND df.file_id = f.file_id (+) ORDER BY df.tablespace_name, df.file_name
prtconf | grep MemPer recuperare informazioni relative ai Core il comando è
psrinfo -pvOltre a questi comandi sono utili anche
uname -a
isainfo -kvper recuperare informazioni sul sistema operativo.
create or replace directory <TARGET_DIR> as '<path>';
grant read, write on directory <TARGET_DIR> to <user_target>;impdp system/<password> SCHEMAS=<schema> \ remap_schema=<user_orig>:<user_target> \ remap_tablespace=<user_orig>:<user_target> \ directory=<TARGET_DIR> \ dumpfile=<DMP_FILE> logfile=<LOG_FILE>
CREATE OR REPLACE DIRECTORY test_dir AS '/u01/app/oracle/oradata/'; GRANT READ, WRITE ON DIRECTORY test_dir TO scott;
expdp scott/tiger@db10g tables=EMP,DEPT directory=TEST_DIR dumpfile=EMP_DEPT.dmp logfile=expdpEMP_DEPT.log impdp scott/tiger@db10g tables=EMP,DEPT directory=TEST_DIR dumpfile=EMP_DEPT.dmp logfile=impdpEMP_DEPT.log
expdp scott/tiger@db10g schemas=SCOTT directory=TEST_DIR dumpfile=SCOTT.dmp logfile=expdpSCOTT.log impdp scott/tiger@db10g schemas=SCOTT directory=TEST_DIR dumpfile=SCOTT.dmp logfile=impdpSCOTT.log
expdp system/password@db10g full=Y directory=TEST_DIR dumpfile=DB10G.dmp logfile=expdpDB10G.log impdp system/password@db10g full=Y directory=TEST_DIR dumpfile=DB10G.dmp logfile=impdpDB10G.log
select lpad(' ', 2*level) || granted_role "User, his roles and privileges" from ( /* THE USERS */ select null grantee, username granted_role from dba_users where username like upper('%&enter_username%') /* THE ROLES TO ROLES RELATIONS */ union select grantee, granted_role from dba_role_privs /* THE ROLES TO PRIVILEGE RELATIONS */ union select grantee, privilege from dba_sys_privs ) start with grantee is null connect by grantee = prior granted_role;
select
lpad(' ', 2*level) || c "Privilege, Roles and Users"
from
(
/* THE PRIVILEGES */
select
null p,
name c
from
system_privilege_map
where
name like upper('%&enter_privliege%')
/* THE ROLES TO ROLES RELATIONS */
union
select
granted_role p,
grantee c
from
dba_role_privs
/* THE ROLES TO PRIVILEGE RELATIONS */
union
select
privilege p,
grantee c
from
dba_sys_privs
)
start with p is null
connect by p = prior c;
select
case when level = 1 then own || '.' || obj || ' (' || typ || ')' else
lpad (' ', 2*(level-1)) || obj || nvl2 (typ, ' (' || typ || ')', null)
end
from
(
/* THE OBJECTS */
select
null p1,
null p2,
object_name obj,
owner own,
object_type typ
from
dba_objects
where
owner not in
('SYS', 'SYSTEM', 'WMSYS', 'SYSMAN','MDSYS','ORDSYS','XDB', 'WKSYS', 'EXFSYS',
'OLAPSYS', 'DBSNMP', 'DMSYS','CTXSYS','WK_TEST', 'ORDPLUGINS', 'OUTLN')
and object_type not in ('SYNONYM', 'INDEX')
/* THE OBJECT TO PRIVILEGE RELATIONS */
union
select
table_name p1,
owner p2,
grantee,
grantee,
privilege
from
dba_tab_privs
/* THE ROLES TO ROLES/USERS RELATIONS */
union
select
granted_role p1,
granted_role p2,
grantee,
grantee,
null
from
dba_role_privs
)
start with p1 is null and p2 is null
connect by p1 = prior obj and p2 = prior own;#!/bin/sh # This is some secure program that uses security. VALID_PASSWORD="secret" #this is our password. echo "Please enter the password:" read PASSWORD if [ "$PASSWORD" == "$VALID_PASSWORD" ]; then echo "You have access!" else echo "ACCESS DENIED!" fi
| -eq | equal to |
| -ne | not equal to |
| -lt | less than |
| -le | less than or equal to |
| -gt | greater than |
| -ge | greater than or equal to |
| -s | file exists and is not empty |
| -f | file exists and is not a directory |
| -d | directory exists |
| -x | file is executable |
| -w | file is writable |
| -r | file is readable |