We can change Oracle Database Name Manually without using nid utility. In this video i am showing you we can change database name using modifying controlfile. First we take a backup of controlfile. alter database backup controlfile to trace as '/location'; Modify some parameter in this controlfile backup. In the place of Reuse Set Old Database name New Database Name Noresetlogs Resetlogs It is very easy to understand. Follow this steps.
Views: 613 Parag Mahalle
How to check existing tablespace information in database ========================================================= select tablespace_name from dba_tablespaces; How to create a tablespace =============================== create tablespace king datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\KING01.DBF' size 10m; How to Resize the datafile ========================== alter database datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\KING01.DBF' resize 20m; Adding a datafile to a tablespace ================================= alter tablespace king add datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\KING02.DBF' size 10m; How to get the defintion of tablespace ====================================== set head off echo off select 'select dbms_metadata.get_ddl(''TABLESPACE'',''' || tablespace_name || ''') from dual;' from dba_tablespaces;
Views: 938 Praveen Biyyapu
RENAME OR MOVE A DATAFILE (when there is space issue in os level file movement is required) ========================== 1)TABLESPACE SHOULD BE OFFLINE(when we move or rename a datafile users should not access) 2)FROM OS LEVEL DATAFILE COPY TO NEW LOCATION 3)SQL LEVEL RENAME THE DATAFILE TO NEW LOCATION 4)MAKE THE TABLESPACE ONLINE alter tablespace king offline; os level rename king01.dbf TO GOODKING01.dbf os level move the file to new location(KING02.DBF) alter tablespace king rename datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\KING01.DBF' to 'E:\DATABASE\DATABASE\ORADATA\ORCL\GOODKING01.DBF'; alter tablespace king rename datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\KING02.DBF' TO 'D:\ORADATA\KING02.DBF'; alter tablespace king online; HOW TO CHECK DATAFILES INFO IN PARTICULAR TABLESPACE ===================================================== COL FILE_NAME FOR A50 COL TABLESPACE_NAME FOR A20 select tablespace_name,file_name from dba_data_files where tablespace_name like '&tablespace_name';
Views: 818 Praveen Biyyapu
How to create Database manually. Asuming that Oracle Software has been installed properly. check other videos if you haven't. Check the oracle contents and Oracle SID, other parameters in the bash_Profile. Step 1 of this video Pre-requisites are completed. Step 2:Go to the dbs directory. copy the file initSID.ora Modify the directories and names accordingly as shown in the video. Save the file Step 3: Create all the new directories using mkdir -p command. Verify the directory structure. Step 4: We need to create the database. Make sure there aren't any oracle processes. Careful that there are no oracle processes. Start the database in nomount state. Check the contents of the script. Prepare one script as such with your names and directories. Keeping higher values temporarily for speedy installation process. Control file reuse is a good option which helps in rerunning the scripts. Execute this file with @createdb. Sit back and db to be created. DB got created in 1min. Step 5: Creating internal views and giving privileges. Check and create other script with the information provided. Contents are not as customized to earlier one. You can simply copy and execute this. Once all these scripts are completed. You can check the objects and do basic checking for the health of the Database. Enjoy the installation series. Subscribe to this channel to get more and more better videos. Leave comments for your Database preparation. Thanks for your time.. This is Kiran Signing Off
Views: 251 kiran ginni
How to perform incremental backup using Block change tracking in Rman Block Change Tracking : ----------------------------------------------- You can perform fast incremental backup by enabling block change tracking. when perform incremental backup, It writes to a file the physical address of each block that is changed. Rman can look the block change tracking file & backup only those blocks refer there. It does not have to scan every block to see if it has changed since the last backup. How to Enable block change tracking? ----------------------------------------------------------------------- Alter database enable block change tracking using file (file path) reuse; 1. We can check Block change tracking is enable or not using v$block_change_tracking View. 2. When block change tracking is enable CTWR process is started.
Views: 453 Parag Mahalle
The Oracle DROP TABLESPACE command is used to remove a tablespace from the database. In the following example, we will drop the USELESS tablespace from our database using the Oracle DROP TABLESPACE command: Drop tablespace useless; The Oracle DROP TABLESPACE command Oracle will generate an error if objects reside in the tablespace. Do the following to remove all objects in the tablespace prior to using Oracle DROP TABLESPACE command: Drop tablespace useless including contents; Oracle does not clean up after itself wile using the Oracle DROP TABLESPACE command by default. An option exists to force Oracle to clean up after itself using the Oracle DROP TABLESPACE command. The following example illustrates the Oracle DROP TABLESPACE command used with the including contents and datafiles keywords: Drop tablespace useless including contents and datafiles;
Views: 153 Mohammad Taseen
informatica reusable transformations, informatica videos, informatica online training, online informatica training.reusable transformations in informatica with example, transformation developer in informatica, transformation developer tool in informatica
Views: 231 Venkat KS
ORACLE DATA INTEGRATOR ODI Filter(where) condition component
Views: 226 srinu bondada
ORACLE DATA INTEGRATOR ODI master and work repository
Views: 111 srinu bondada
Controlling PowerCenter workflows logic using the data read in a mapping.
Views: 1278 InfaMarketplace
Learn about a recent project for a top pharmaceutical company that entailed the merging of multiple drug safety systems. -- Many sponsors and CROs rely on an IT infrastructure that includes multiple disconnected safety and pharmacovigilance systems that vary by region and vendor. Although merging these systems into a single global solution may seem daunting and provide you with many technical challenges, it could be a crucial goal on the horizon for your organization. Please join BioPharm Systems' Dr. Rodney Lemery, vice president of safety and pharmacovigilance, for this free one-hour webinar in which he will review a recent project for a top pharmaceutical company that entailed the merging of multiple drug safety systems into one global Argus Safety pharmacovigilance system. Specific topics that will be examined include: -Adverse Event Case Migration -Merging and Configuring -Data Cleansing and Consistency -Configuring Reporting Rules To view this webinar in its entirety, please visit: http://www.biopharm.com or https://cc.readytalk.com/r/kuqj4f3gwl42. Twitter: http://www.twitter.com/BioPharmSystems Facebook: http://www.facebook.com/BioPharmSystems LinkedIn: http://www.linkedin.com/companies/biopharm-systems-inc Google+: https://plus.google.com/104105608638786200757
Views: 2021 BioPharmSystems