Linux: Set Environment Variable

Step -1

Need to vi (Editor) to .bashrc

vi .bashrc

Now check prior to add it is showing blank 

Step -2

Add the environment variable which we want to add like

export my_path=/home/user

Now save and exit

Esc
:wq!

Now update the .bashrc

. .bashrc  enter

Now check echo $my_path








All Steps -

1. vi .bashrc
2. export my_path=/home/user
3. Esc :wq!
4.  . .bashrc
5. echo $my_path

Thanks
DB Tech Solutions

Show all installed packages or software in Linux all flavours...

Below mentioned command to get list of softwares and packages installed on linux operation system with all flavours -

First need to root access or sudo su with sudo access user -


Red Hat/Fedora Core/CentOS Linux
# rpm -qa | less

Core/CentOS Linux
# rpm -qa | less

Debian Linux
# dpkg --get-selections

Ubuntu Linux
# sudo dpkg --get-selections

FreeBSD
# pkg_info | less
# pkg_info apache

pkg_version command to summarises the versions of all installed packages
# pkg_version | less
# pkg_version | grep 'lsof'


OpenBSD
# pkg_info | less
# pkg_info apache

Thanks
DB Tech Solutions

How to export between releases of oracle

Below script to export from 12c and import that dump into 11g to use version parameter -


expdp user/password@db directory=<directory_name> dumpfile=<dumpfile_name>.dmp logfile=<logfile_name>.log tables=<table_name> job_name=<job_name> version=11.2

how to import multiple partition using impdp

Dump for entire schema available now we require to import 3 partition only into the another schema

Script-

impdp test/test
directory=dumpfile
dumpfile=user_full_schema.dmp
logfile=multiple_partition_import_remap_schema.log
tables=user.tablename1:partitionname1,user.tablename1:partitionname2,user.tablename1:partitionname3
remap_schema=user:test


Note: It will create a table with all partitions but data will import only above mentioned partitioned. Don't Worrry..

If any additional help is required Please write us at : dbtechsolutions17@gmail.com

Thanks
DB Tech Solutions