Search results “Oracle utl file create directory”
how to create directory in oracle 12c, 11g
Use the CREATE DIRECTORY statement to create a directory object. A directory object specifies an alias for a directory on the server file system where external binary file LOBs and external table data are located. You can use directory names when referring to BFILEs in your PL/SQL code and OCI calls, rather than hard coding the operating system path name, for management flexibility. All directories are created in a single namespace and are not owned by an individual schema. You can secure access to the BFILEs stored within the directory structure by granting object privileges on the directories to specific users. You must have CREATE ANY DIRECTORY system privilege to create directories. When you create a directory, you are automatically granted the READ and WRITE object privileges on the directory, and you can grant these privileges to other users and roles. The DBA can also grant these privileges to other users and roles. WRITE privileges on a directory are useful in connection with external tables. They let the grantee determine whether the external table agent can write a log file or a bad file to the directory. For file storage, you must also create a corresponding operating system directory, an ASM disk group, or a directory within an ASM disk group. Your system or database administrator must ensure that the operating system directory has the correct read and write permissions for Oracle Database processes. Privileges granted for the directory are created independently of the permissions defined for the operating system directory, and the two may or may not correspond exactly. For example, an error occurs if sample user hr is granted READ privilege on the directory object but the corresponding operating system directory does not have READ permission defined for Oracle Database processes. ---------------------------------------------------------------------------- Default directory is DATA_PUMP_DIR.Below command is to get directory name and directory path. SELECT directory_name, directory_path FROM dba_directories WHERE directory_name='DATA_PUMP_DIR' DIRECTORY_NAME DIRECTORY_PATH --------------- ------------------------------------------------------- DATA_PUMP_DIR /u01/app/mohammad75/product/12.1.0/dbhome_1/rdbms/log/
Views: 1990 Oracle DBA World
How to access data from file - External Table - Oracle - Query Data from flat files
In this video we can see what is the external table, how can we use it.... How to access table from a flat file? We can access data from any type of format loaded by SQL*Loader. Code: create or replace directory External_Dir as 'D:\External'; create table External_Table ( v_num number(5), v_name varchar2(20) ) ORGANIZATION EXTERNAL ( TYPE ORACLE_LOADER DEFAULT DIRECTORY External_Dir Access parameters ( RECORDS DELIMITED BY NEWLINE FIELDS TERMINATED BY ',' ) LOCATION('Sample_File.txt') );
Using Oracle UTL_FILE
Using Oracle UTL_FILE for more info maxvlearn.com
Views: 1872 khaled alkhudari
creating a directory object en oracle Database 11g
creando un directorio en donde se guardaran nuestros dumps con el Enterprise Manager 11g http://www.mrlocooracle.com
Views: 2732 MrOracle Adolfo Luna
Solving ORA 29283 invalid file operation error
In this tutorial you will learn how to resolve ORA 29283 error.
Views: 496 DBA Pro
1_2 Create user & Home Directory for Oracle
create oracle user and home directory for the installation of Oracle 11g R2 on Redhat Enterprise Linux 7
Views: 201 Rinku Kumar Singh
IO4: Rename, Move, Copy Files with UTL_FILE
UTL_FILE offers a number of high-level subprograms to perform activities like copying a file, renaming a file, and removing a file. Download my demo.zip from v.gd/sfdemo to access and run all referenced scripts. This video was taken from PLSQLChannel.com, originally recorded before Steven Feuerstein re-joined Oracle in March 2014. ======================================== Practically Perfect PL/SQL with Steven Feuerstein Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Oracle SQL PLSQL and Unix Shell Scripting
Views: 2252 Sridhar Raghavan
External Table in ORACLE Creating and Loading data from external tables
External Table in ORACLE Creating and Loading data from external tables. To Learn or Teach Linux visit www.theskillpedia.com, A Marketplace for Learners and Trainers. Creating and Loading an External Table Using ORACLE_LOADER The steps in this demonstration show an example of using the ORACLE_LOADER access driver to create and load an external table. A traditional table named emp_list is defined along with an external table named emp_load. The external data is then loaded into an internal table. Step 1. Log in as oracle user and create a Directory to place the data file /u01/app/datafiles: $ mkdir –p /u01/app/datafiles Step 2 Create a file emp_data.dat file with some sample records in /u01/app/datafiles: 45 october, 25, 1968 Sangwan Ram N 09/01/1993 67 december, 25, 1971 Dahiya Sunil D 01/01/1994 Step 3. Execute the following SQL statements to set up a default directory. Notes about this example: • The employee_number field in the datafile is converted to a character string for the employee_number field in the external table. • The datafile contains an employee_dob field that is not loaded into any field in the table. • The substr function is used on the employee_middle_name column in the external table to generate the value for middle_initial in tableemp. • The character string for employee_hire_date in info.dat is automatically converted into a DATE datatype at external table access time, using the format mask specified in the external table definiition. • Unlike employee_hire_date, the DATE datatype conversion for employee_dob is done at SELECT time and is not part of the external table definition.
Views: 4426 TheSkillPedia
Manejo y almacenamiento de datos BLOB
Esta es una exposición acerca de los datos BLOB en las base de datos. El código comentado del ejercicio práctico es el siguiente: CREATE DIRECTORY DIR_TEMP AS 'S:\tempExample'; SELECT * FROM ALL_DIRECTORIES; CREATE TABLE TABLA_BLOB ( id NUMBER, valor BLOB DEFAULT EMPTY_BLOB() ) SET serveroutput ON DECLARE v_blob BLOB; v_bfile BFILE; BEGIN INSERT INTO TABLA_BLOB(id, valor) VALUES (1, EMPTY_BLOB()) RETURNING valor INTO v_blob; v_bfile := BFILENAME('DIR_TEMP', 'img.jpeg'); DBMS_LOB.OPEN(v_bfile, DBMS_LOB.LOB_READONLY); DBMS_LOB.LOADFROMFILE(v_blob, v_bfile, SYS.DBMS_LOB.GETLENGTH(v_bfile)); DBMS_LOB.CLOSE(v_bfile); COMMIT; END; SELECT * FROM TABLA_BLOB; SET serveroutput ON DECLARE v_blob BLOB; v_archivo UTL_FILE.FILE_TYPE; v_offset NUMBER:=1; BEGIN SELECT valor INTO v_blob FROM TABLA_BLOB WHERE id = 1; v_archivo := UTL_FILE.FOPEN('DIR_TEMP', 'new.jpeg', 'WB', 32767); LOOP EXIT WHEN v_offset *simbolo_mayorQue* DBMS_LOB.GETLENGTH(v_blob); UTL_FILE.PUT_RAW(v_archivo, DBMS_LOB.SUBSTR(v_blob, 32767, v_offset)); v_offset:=v_offset + 32767; END LOOP; UTL_FILE.FCLOSE(v_archivo); END; DROP TABLE TABLA_BLOB; DROP DIRECTORY DIR_TEMP;
Views: 1433 Adriano Fazio
63/125 Oracle PLSQL: Supplied  Packages / UTL_FILE  2
if you face issue remember to do this grant READ, WRITE on DIRECTORY MYDIR to public; تعلم اوراكل حتى الاحتراف Learn Oracle PLSQL EXAM 1Z0-144
Views: 522 khaled alkhudari
Data loading from flie to table using SQL*LOADER
Load the data from Flat file to database table using SQL*LOADER concept in Oracle Applications.
Oracle(How to create a spool file or list file in Oracle)
how to create a list file or spool file in oracle ...
Views: 12315 sreetheja amilineni
Oracle Forms || How To Create PL/SQL Library -30
Oracle Forms || How To Create PL/SQL Library -30 To See More Forms Tutorial Click here https://www.youtube.com/watch?v=Zsu4CWo_vwk&list=PLXXvCMuixAJU3Ap_FE2zSEBicv8IC5kDU To See More Reports Tutorial Click here https://www.youtube.com/watch?v=y_0f_iILlmY&list=PLXXvCMuixAJUfU4ZISmPtHrmKe5qRvyVY About PL/SQL Library: - A library is a collection of PL/SQL program units, including procedures, functions, and packages. A single library can contain many program units that can be shared among the Oracle Developer modules and applications that need to use them. - Pl/SQL Libraries generally contain procedures, functions and packages. Create multi_fun in the function: Code: FUNCTION multi_fun ( p number, q number) return number IS v_record number(20); BEGIN select p * q into v_record from dual; return v_record; END; Create multi_button in the procedure: Code: PROCEDURE multi_button IS BEGIN IF name_in(':SYSTEM.TRIGGER_ITEM')='CONTROL.BSAVE' THEN commit_form; clear_form(no_validate); ELSIF name_in(':SYSTEM.TRIGGER_ITEM')='CONTROL.BEXIT' THEN exit_form(no_validate); ELSIF name_in(':SYSTEM.TRIGGER_ITEM')='CONTROL.BCLEAR' THEN clear_form(no_validate); ELSIF name_in(':SYSTEM.TRIGGER_ITEM')='CONTROL.BQUERY' THEN execute_query; ELSIF name_in(':SYSTEM.TRIGGER_ITEM')='CONTROL.BDELETE' THEN delete_record; commit_form; ELSIF name_in(':SYSTEM.TRIGGER_ITEM')='CONTROL.PREVIOUS' THEN previous_record; ELSIF name_in(':SYSTEM.TRIGGER_ITEM')='CONTROL.NEXT' THEN next_record; END IF; END; To Get more Tutorial Subscribe The Channel click here https://www.youtube.com/channel/UCQ3ea4zVCfnKBx1_7h8raGQ?sub_confirmation=1 To Get All Post Like The Facebook Page Click here https://www.facebook.com/oracledbsolutions Follow us: Facebook: https://www.facebook.com/oracledbsolutions Youtube link: https://www.youtube.com/channel/UCQ3ea4zVCfnKBx1_7h8raGQ?view_as=subscriber Facebook Group: https://www.facebook.com/groups/465557066961548 Contact us: email: [email protected] Skype: oracle26solutions Mob: 01734557080, 01627422780
Views: 326 OracleDB Solutions
Oracle Data Export and Import using DataPump expdp and impdp
Oracle Data Export and Import using DataPump expdp and impdp
Views: 173629 Abbasi Asif
Calling a Web Service from Oracle Database Without Using Oracle Wallet
following would be the things you would be learning after watching this video Calling a Web Service from Oracle Database Without Using Oracle Wallet. Things Needed to call the Web Service: Batch File Database Directory Database Jobs Database Procedure Utl_file Procedure to Call Clob Table Calling a https web service with basic Authentication without using Oracle Wallet
Views: 318 MrBajajpankaj
Oracle Database Tutorial 52 : Data Pump expdp - How to Export full database using expdp
Oracle Database tutorial/SQL Tutorial 52 On Data Pump expdp utility here in this tutorial you'll learn how to export full/complete Database using expdp data pump utility of oracle Database ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/database-full-export-using-expdp Tut 48 Roles: http://youtu.be/tyYxSrCXzCM ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 72264 Manish Sharma
File Upload Using Oracle APEX
Views: 32052 Eddie Awad
Unix shell scripting Hard link Soft or Symbolic link
Oracle SQL PLSQL and Unix Shell Scripting
Views: 142 Sridhar Raghavan
Window Lock Example
simple window lock code using java.
Views: 90 deep Singh
Oracle LOBS
Oracle LOBS
Views: 1754 The Silent DBA
Views: 56 Toscalito Support
Uso del Directorio
Las aplicaciones de Oracle Cloud ponen a disposición de sus usuarios un Directorio interactivo que permite búsquedas a través de diversos criterios y permite ver el organigrama general así como detalles del personal.
Views: 77 STO Consulting
Часть 0. Oracle Database. Установка Oracle Linux 7 1 в Virtual Box и установка Oracle XE
Видео-мануал по установке Oracle Linux в VirtualBox и установка Oracle XE. Содержимое файлов настроек и скрипты: Содержимое файла .bash_profile. Открываем: nano /root/.bash_profile Вставляем: #Oracle install specific environment settings umask 022 TMP=/tmp; export TMP TMPDIR=$TMP; export TMPDIR ORACLE_HOSTNAME=localhost.localdomain; export ORACLE_HOSTNAME ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe; export ORACLE_HOME ORACLE_SID=orcl; export ORACLE_SID ORACLE_TERM=xterm; export ORACLE_TERM PATH=$ORACLE_HOME/bin:/usr/sbin:$PATH; export PATH LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH CLASSPATH=$CLASSPATH:$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH NLS_LANG=AMERICAN_AMERICA.CL8MSWIN1251; export NLS_LANG Ctrl+O сохранить, Ctrl+X выйти из nano. В mc - F4 редактировать файл, F2 - сохранить, F10 выйти Открываем порт 1521 и 8080 в Firewall на Oracle Linux 7.1: firewall-cmd --zone=public --add-port=1521/tcp --permanent ; firewall-cmd --zone=public --add-port=8080/tcp --permanent ; firewall-cmd --reload ; firewall-cmd --zone=public --list-ports Должно быть так: success success success 1521/tcp 8080/tcp Команды создания пользователя вставляем в SQL Navigator или SQL Developer: --DROP USER analytic CASCADE; --Это удаление пользователя и всех его данных. CREATE USER analytic IDENTIFIED BY 123456; --123456 - это пароль. GRANT CREATE SESSION TO analytic; --право подключаться. Ѕез него невозможно залогиниться в Oracle --под этим пользователем. GRANT CREATE TABLE TO analytic; --право создавать таблицы GRANT CREATE PROCEDURE TO analytic; --право создавать процедуры GRANT CREATE TRIGGER TO analytic; --право создавать триггеры GRANT CREATE VIEW TO analytic; --право создавать представления GRANT CREATE SEQUENCE TO analytic; --право создавать последовательности GRANT CREATE LIBRARY TO analytic; --право создавать внешние процедуры/библиотеки GRANT CREATE ANY DIRECTORY TO analytic; GRANT DROP ANY DIRECTORY TO analytic; --право создавать, удалять, читать и писать в директории GRANT CREATE PUBLIC SYNONYM TO analytic; GRANT EXECUTE ON SYS.UTL_HTTP TO analytic; GRANT EXECUTE ON SYS.UTL_FILE TO analytic; GRANT EXECUTE ON SYS.utl_smtp TO analytic; GRANT EXECUTE ON SYS.utl_xml TO analytic; --права на использование пакетов ALTER USER analytic QUOTA UNLIMITED ON USERS; ALTER USER analytic QUOTA UNLIMITED ON SYSTEM; --раздаем квоты на использование места - неограничено. COMMIT; --подтверждение сделанных в данной сессии операций Access Control List не могу опубликовать, с видео тащите. Гугл не позволяет писать скобки в описании видео. Но в принципе ACL и не нужен большинству из вас.
Create an employee as a manager in Oracle R12 apps
In this video tutorial, we can see how to create an employee in Oracle R12 Applications as a manager.
Using Oracle SQL Loader
Demonstration of how to use Oracle's SQL Loader to load flat file data into a database; log, bad, and discard files are addressed, along with troubleshooting load errors
Views: 61383 Stephen Frein
Unix shell script to read a file line by line and read word by word from each line
Oracle SQL PLSQL and Unix Shell Scripting
Views: 3649 Sridhar Raghavan
Output to CSV File
Move Data From SQL Database to CSV File
Views: 1064 Mike
Export data from Oracle Database Cloud Service
This video will show you how to export data from Oracle Database Cloud Service, and download it from your secure FTP download area in the outgoing directory. Note that files are retained for 48 hours. ================================= To improve the video quality, click the gear icon and set the Quality to 1080p/720p HD. For more information, see http://www.oracle.com/goto/oll and http://docs.oracle.com Copyright © 2017 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
How to Import CSV, Excel, TXT  into Oracle Database With Oracle SQL Developer
This question comes up about as frequently as the ‘how do I import data to Oracle Database’ question. It’s pretty simple once you’ve ran through the process a few times. But you may be here because you’ve never ran through the process before.
Views: 17573 Tayyib Oladoja
How to Run an .sh file in Linux
Get that script going!
Views: 1393 teklek411
How to create Text or CSV File Dynamically from a Stored Procedure in SSIS Package-P180
SSIS Tutorial Scenario: How to create Text or CSV File Dynamically from a Stored Procedure in SSIS Package You are working as SQL Server Integration Services developer. You need to create an SSIS Package that should execute Stored Procedure and write the results to flat file. Every time the SSIS Package will run, it should create new flat file with date-time. This is simple requirement. You might think to use OLE DB Source and then use Flat file destination. But there is small problem. The definition of Stored Procedure can change anytime, that means the number of columns returned by Stored Procedure can change. You need to develop an SSIS Package in such a way that you don't have to reopen and remap the columns every-time the definition of Stored Procedure change. link to script used in the video http://www.techbrothersit.com/2016/04/how-to-create-text-or-csv-file_7.html Check out http://www.techbrothersit.com/ for free Technology Tutorials /Interview Questions SQL Server Integration Services(SSIS) Tutorial SQL Server Reporting Services (SSRS) Tutorial SQL Server / TSQL Tutorial SQL Server DBA Tutorial Team Foundation Server Microsoft Dynamics AX
Views: 7587 TechBrothersIT
Oracle Tutorial || Oracle|Adv Sql | Datatypes - BFile by basha
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonline.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
Oracle Upgrade, oracle 10g and oralce 11g to oracle 12c
SAP On Oracle Database Upgrade, From Oracle 10g to 12c Direct upgrade, ================================================= TAKE BACKUP OF EXISITNG DB brbackup -u / -p initGWP-disk-OFF.sap -d disk -t offline -m all -o time INSTALL ORACLE 12 DATA BASE - CHANGE THE HOME DIRECTORY PATH IN ENVIRONEMNT - Not to ADD FULL PERMISSION IN TO ORALCE INSTALLATION USER - TAKE A COPY OF OLD ORACLE & AND NEW ORACLE HOME BEFORE APPLYING PATCHES - TAKE COPY OF NETWORK\ADMIN AND DATABASE FOLDER - DOWNLOADED LATEST OPATCH AND REPLACE OPATCH FOLDER - APPYL NEEDED PATCHES USING OPATCHS - STOP ALL SERVICES ORACLE RELATED FOR APPLYINT PATCHES **PATCHBUNDLE12102P_1702-20012303.zip **PATCHBUNDLE12102P_1704-20012303.zip **P9584028GEN12102P_2-20012303.zip 'EG: B:\Patches\P9584028GEN12102P_2-20012303\9584028 C:\oracle\GWP\12102\OPatch\OPATCH APPLY' 'EG: B:\Patches\PATCHBUNDLE12102P_1702-20012303\25433286 E:\oracle\GWQ\12102\OPatch\OPATCH APPLY' "EG: B:\Patches\PATCHBUNDLE12102P_1704-20012303\25632533 E:\oracle\GWQ\12102\OPatch\OPATCH APPLY" -START SERVICES AFTER APPLYING PATCHES FOR UPGRADE. RUN THE PRE UPGRADE SCRIPT AS FOLLOWS.. PRE UPGRADE SCRIPT WILL PROVIDE YOU WHEN YOU UPDATE PATCHES ================================ OS sqlplus / as sysdba SQL @pre_upgrade_tasks.sql SQL @pre_upgrade_checks_ora.sql SQL @pre_upgrade_checks_sap.sql THEN CREATE RESTORE POINT FOR RECOVERY IF ANY FAILIUR HAPPEND */ ============================================================= /*(ALTER SYSTEM SET db_recovery_file_dest_size='10G G:\oracle\GWP\oraflash' scope=both; ALTER SYSTEM SET db_recovery_file_dest= 'E:\oracle\GWQ\oraflash scope=both';)*/ ------------------------------------------- SQL @grp_create_restore_point.sql SQL @grp_list_restore_point.sql ===TAKE BACKUP OF NETWORK/ADMIN & ORAHOME\DATABASE RUN DUBA from new home (oralce 12c) KEEP DATABSE OPEN FOR UPGRADE. ===================== CREATE RMAN BACKUP DURING THE UPGRADE \Post upgrade steps 1915315 - Database Upgrade Scripts for ====================================================================== After DUB create Listner or check the listner status LSNRCTL/ Go to directory 'post_upgrade' to run the post-upgrade scripts. --SQL @?/rdbms/admin/utlu121s.sql --SQL @?/rdbms/admin/utluiobj.sql --SQL @post_upgrade_tasks.sql Recompile invalid objects --SQL @?/rdbms/admin/utlrp.sql Run post-upgrade checks --SQL @post_upgrade_checks.sql Check whether guaranteed restore point 'GRP_BEFORE_UPGRADE_12102' exists: OS cd NEW_ORACLE_HOME /sap/ora_upgrade/pre_upgrade OS sqlplus / as sysdba --SQL @grp_list_restore_point.sql you need to drop this restore point and set 'COMPATIBLE' to the new value. OS cd NEW_ORACLE_HOME /sap/ora_upgrade/pre_upgrade OS sqlplus / as sysdba --SQL @grp_drop_restore_point.sql OS cd NEW_ORACLE_HOME /sap/ora_upgrade/post_upgrade OS sqlplus / as sysdba --SQL @set_compatible.sql After setting compatible to a new value, 'RESTART THE DATABASE.' Ensure that parameter 'compatible' is set to '' or '': --SQL SHOW PARAMETER COMPATIBLE SQL show parameter compatible NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ compatible string noncdb_compatible boolean FALSE --SQL SELECT VALUE "COMPATIBLE" FROM V$PARAMETER WHERE NAME = 'COMPATIBLE'; Before you start the remaining database post-upgrade tasks you can create a new guaranteed restore point ====================================================== --SQL CREATE RESTORE POINT "'GRP_AFTER_UPGRADE_12102'" GUARANTEE FLASHBACK DATABASE ; --SQL SELECT NAME FROM V$RESTORE_POINT WHERE GUARANTEE_FLASHBACK_DATABASE = 'YES'; drop V$RESTORE_POINT WHERE GUARANTEE_FLASHBACK_DATABASE = 'YES'; Check for invalid objects: =========================== --SQL select owner, object_name, object_type from dba_objects where status = 'INVALID'; If the object 'DBMS_METADATA' (package body) is still invalid (Ref: patch 17871192), run utlrp to recompile the package. ====================================================== --SQL @?\rdbms\admin\utlrp.sql --SQL select owner, object_name, object_type from dba_objects where status = 'INVALID'; COPY data from OLDorahome\database\ to new database\ FOLLOWING FILES INIT SID .SAP INIT SID .UTL update the kernel CHEK THE TNS FILE NAME IN NETWORK\ADMIN brconnect -u / -c -f stats -t system_stats brconnect -u / -c -f stats -t oradict_stats brconnect -u / -c -f stats -t all -f collect -p 4 deinstall the 11g /*if needed */{}{}{}{}{}{}{}{}{}{}{}{}{}{}{} ================= sqlplus / as sysdba @sapuprof_profile Insufficent privillege 134592 - Import of SAPDBA role (sapdba_role.sql) ========================== sqlplus /nolog @sapdba_role SAPSR3 --CHANGE PARAMTER ONCE UPGRADE COMPLETE. Visit My Blog:http://wrongcodes.blogspot.com/
Views: 118 SNOOPPY TV
Video capture of creating a xlsx file which connects to a sql server database and saves it to a sheet.
Views: 555 Jon Lal
Multiple File Uploading in Oracle ADF
How to Upload Multiple Files using af:inputFile in Oracle ADF- http://www.awasthiashish.com/2017/01/uploading-mulitiple-files-to-server.html
Insert large Data using command prompt into sql
Insert large Data using command prompt into ms sql database
Views: 85 Syed Ali
FTP Server - how to setup and access files from any where
how to create an FTP server to access your files from any where
Views: 255 Andrew Blanche
PLSQL#1 UTLFILESを用いたTXTファイル読み込み(その1)/IT0019
●説明)0.概説 0-1.イントロダクション (0:00) 0-2.作業の流れの説明 (0:39) (1)事前準備:ディレクトリオブジェクトの作成(CREATE DIRECTORY) (2)事前準備:ユーザにディレクトリオブジェクトのREAD/WRITE権限を付与する (3)事前準備:ユーザに"UTL_FILE"パッケージのEXECUTE権限を付与する (4)コーディング (5)コンパイル・実行 (6)結果確認 ●実演)1.表領域の作成 (2:06) ~【作業場所:Oracle DB】~~~ (0)SQL*Plusがある階層へ移動 & 起動 & ログイン (2:06) $ cd /u01/app/oracle/product/11.2.0/dbhome_1/bin $ ./sqlplus /nolog SQL> CONN SYSTEM/[PASS] AS SYSDBA (1)事前準備:ディレクトリオブジェクトの作成(CREATE DIRECTORY) (3:36) $ CREATE DIRECTORY RBWEG_0001 AS '/tmp/plsqltest-20170916'; (2)事前準備:ユーザにディレクトリオブジェクトのREAD/WRITE権限を付与する (5:05) $ GRANT READ ON DIRECTORY RBWEG_0001 TO RBWEGUSR ; $ GRANT WRITE ON DIRECTORY RBWEG_0001 TO RBWEGUSR ; (3)事前準備:ユーザに"UTL_FILE"パッケージのEXECUTE権限を付与する $ GRANT EXECUTE ON UTL_FILE TO RBWEGUSR; ~~~~~~~~~~~~~~~~
Executing OS Commands from RMAN
Many a times , we may need to run some Operating System Commands while working with RMAN . This video explains the different methods to execute OS Commands while working with RMAN. For more course details please visit www.wysheid.com
Views: 530 Wysheid Wysheid
SQLLoader Express Mode
#Oracle #SQLLoader #ExpressMode
Views: 190 Hemant K Chitale
Grub Error Rescue: Get Back to OS - Windows/Linux
This is a video on how to get back to your OS, when you get the Error: Grub Rescue. Super Grub Disk is a bootable floppy or CDROM that is oriented towards system rescue, specifically for repairing the booting process. Super Grub Disk is simply a Grub Disk with a lot of useful menus. It can activate partitions, boot partitions, boot MBRs, boot your former OS (Linux or another one) by loading menu.lst from your hard disk, automatically restore Grub on your MBR, swap hard disks in the BIOS, and boot from any available disk device. Super Grub Disk project has multi-language support, and allows you to change the keyboard layout of your shell. Super Grub Link: http://linux.softpedia.com/get/System/Recovery/GRUB-Disk-15969.shtml Subscribe for more Ubuntu videos.
Views: 228956 UbuntuHelpGuy
Application Express upgrade to version 5.1.4
After installation of Oracle XE upgrade to the latest version 5.1.4, also export and import the XE admin application and install SSH. The exp_4950.sql script can be found on https://linuxsqltips.blogspot.com.ee/2018/03/upgrading-oracle-apex-to-514.html Please like, share and subscribe.
Views: 128 Paul Williams

Job cover letter salutation line
Yazzy application letters
Paper writing service online
How to write a cover letter for a resume samples
Help with writing resume and cover letter