IS 'This is a multi-line comment for your table.
It provides additional information about the table structure and purpose.';
How to find failed tables after export/import job has done on Oracle Database ?
Enable supplemental logging for a specific table:-
ALTER TABLE your_schema.your_table ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
crs_stat -t :- show HA resource status
crsstat :- output of crs_stat -t formatted nicely
ps -ef | grep d.bin :- crsd.bin evmd.bin ocssd.bin
crsctl check crs :- css, crs, evm appears healthy.
crsctl stop crs :- stop crs and all other services.
crsctl disable crs* :- prevents crs from starting on reboot.
crsctl enable crs* :- enables crs start on reboot.
crs_stop -all :- stops all regiestered resources.
crs_start -all :- starts all registered resources.
srvctl start instance -d <db_name> -i <inst_name> :- starts an instance.
srvctl start database -d <db_name> :- starts all instances.
srvctl stop database -d <db_name> :- stops all instances.
srvctl stop instance -d <db_name> -i <inst_name> :- stops an instance.
srvctl start service -d <db_name> -s <service_name> :- starts a service.
srvctl stop service -d <db_name> -s <service_name> :- stops a service.
srvctl status service -d <db_name> :- check status of a service.
srvctl status instance -d <db_name> -i <inst_name> :- checks status of instance
srvctl status database -d <db_name> :- checks status of all instances.
srvctl start nodeapps -n <node_name> :- starts gsd, vip, listener and ons
srvctl stop nodeapps -n <node_name> :- stops gsd, vip, listener and ons
cat /etc/profile
cat ~/.profile
cat ~/.bash_profile
cat /etc/oraInst.locinventory_loc=/u01/app/oraInventory inst_group=oinstall
select inst_id,name,value from v$diag_info;
best for finding exact location of archivelog location in oracle linux:-
select dest_name,status,destination from gv$archive_dest where status='VALID';
SELECT name, space_limit, space_used FROM v$recovery_file_dest;
shopt -s extglob # Enable extended pattern matching
rm -rf !(folder) # Delete everything except the 'folder' directory
shopt -u extglob # Disable extended pattern matching (optional)
commit: make changes done in transaction permanent.
rollback : rollback the state of database to the last commit point.
savepoint : use to specify a point in transaction to which later you can rollback.
create table student
(
id number primary key,
name varchar2(50),
college varchar2(50)
);
insert all
into student values (1,'pravin','ness')
into student values (2,'prakash','ness')
into student values (3,'pratap','ness')
into student values (4,'pranav','ness')
into student values (5,'prayank','ness')
select * from dual;
--create savepoint student_original --
savepoint student_original;
-- delete some records --
delete student where id=5;
-- rollback to student_original savepoint --
rollback to student_original;
-- most important fact --
you cannot rollback to any previous savepoint once you've triggered commit;
Step 1: Install OpenSSH Server You can do this via PowerShell (run as Administrator ): Check if it's already available: Get-WindowsCapab...