Search results “Create public dblink oracle”
How to Create a Dblink Between Two Oracle Database oracle12c/11g
"Must Watch" How to Create a Dblink Between Two Oracle Database oracle12c/11g instance in different machine. #CreateaDblink #Oracle Database12c/11g Oracle database Unbeatable,Unbreakable Platform..
Views: 10773 Oracle World
How to Create Database Link in Oracle. /* Step By Step /*
Today I am showing you. How to create Database link (DB Link) in Oracle. What is Database Link ( DB Link ) ? A database link is a schema object in one database that enables you to access objects on another database. I have 2 databases 1. paragdb 2. orcl In Paragdb database 1. Create listener 2. Service Name 3. In Orcl Database 1. Create Listener 2. Service Name 3. Create new User 4.Grant connect,resource,create database link to username; 5. open user 6. create database link 1. create database link link1 connect to scott identified by tiger using 'connect_primary''; 7.select * from [email protected]; 8. select * from [email protected]; 9. views 1. select * from user_db_links; 2. select * from all_db_links; 10. conn sys as sysdba 11. grant public database link to username; 12. select * from dba_db_links; 13. conn username/pass 14. create public database link plink connect to scott identified by tiger using 'connect_primary'; 15. drop database link. drop database link link1; To follow this steps you will also create oracle database link. It is very easy to understand.
Views: 8415 Parag Mahalle
How to create and use database link in Oracle
Database link are used to connect to database which is on different host and different instance, where you cannot use schema.table_name. But it gives you the freedom to manipulate the remote database table as if they are located in you own schema. This is the first part of database link video, on next videos will show you how database link can be used in datawarehousing.
Views: 5672 Subhroneel Ganguly
How to Create Database Link Between Two Oracle Databases / Instances | Oracle 11g (R2) | With Syntax
Please watch: "How to Rank Youtube Videos at #1 in Urdu/Hindi 2017, Using Tube Rank Jeet | Youtube SEO | Complete" https://www.youtube.com/watch?v=65dqd_lNpoc -~-~~-~~~-~~-~- For more videos: Subscribe my channel: https://www..com/channel/UCimOZdmTEByzJCpU6ARkuFg?sub_confirmation=1 Website: http://mohammadzohaibsplixed.blogspot.com Emails: [email protected] [email protected] Facebook: https://www.facebook.com/SplixeD (Profile) https://www.facebook.com/MohammadZohaibSplixed (Page) Twitter: https://twitter.com/Mr_Zobi Skype: mohammadzohaibsplixed ----------------------------------------------------------------------------------------- Oracle - Database Links, How to create Database link in ORACLE DISTRIBUTED DATABASE, how to create database link between two oracle databases in oracle 11g release 2 (r2), how to create database link between two oracle instances in oracle 11g release 2 (r2), how to linking databases in oracle 11g release 2 (r2), database linking syntax, database link syntax oracle, oracle database link, - How to Create Database Link in Oracle 11g, - Linking Between Two Oracle Databases, - Create Database Link Oracle 11g, - 如何在Oracle 11g中创建数据库链接, -如何在Oracle 11g中創建數據庫鏈接, -Comment créer un lien de base de données dans Oracle 11g, -Erstellen von Datenbankverknüpfungen in Oracle 11g, -Πώς να δημιουργήσει βάση δεδομένων Σύνδεση στο Oracle 11g, -ओरेकल 11 जी में डाटाबेस लिंक बनाने के लिए कैसे, -Come creare Database Link in Oracle 11g, -Oracle 11g에서 데이터베이스 링크를 생성하는 방법, -Como criar um link de banco de dados no Oracle 11g, -Как создать связь с базой данных в Oracle 11g, -Cómo crear vínculo de base de datos en Oracle 11g, -Як створити зв'язок з базою даних в Oracle 11g , -Oracle 11g ਵਿਚ ਡਾਟਾਬੇਸ ਲਿੰਕ ਬਣਾਓ ਕਰਨਾ ਹੈ, -كيفية إنشاء ارتباط قاعدة البيانات في أوراكل 11g, #Oracle11g #Database #DatabaseLink #Oracle #SplixeD #Tutorial
Oracle - Create Database Link
How to create Database link in ORACLE DISTRIBUTED DATABASE Support: [email protected] Download (video and document): http://www.mediafire.com/download/rre50e9dv439whs/Create_Database_Link_-_ngocle492.rar Vietnamese version: https://www.mediafire.com/folder/5hnygela3n1xs/%5BVideo%5D_Oracle_DBLink
Views: 23555 Lê Ngọc
Using Oracle to read data from SQL Server
Hi everyone, Andy from Easysoft Limited here, what I want to show you today is how to get data from SQL Server into Oracle. Now for this we will be accessing SQL Server 2014 from Oracle 12 and getting data across. This could be quite easily be any SQL Server version from 2008 and any Oracle version from 11.2, the configuration and process is the same. We can obviously get access to data on SQL Server prior to 2008 and Oracle prior to version 11.2 but it will need a different configuration to what I am going to show you today The plan is also to add more data to the SQL Server table and show this new data back in Oracle. To start off you'll need access to ensure that you have access to your SQL Server and Oracle databases. You'll also need the Easysoft SQL Server ODBC Driver available from www.easysoft.com; just download it, install it and request the free 14 day trial licence. Before we start we need to make some changes to the standard Easysoft config files. cat /etc/odbc.ini Here I have changed Mars Connection to Yes. It must be set to "Yes" if you are connecting to SQL Server 2005 or newer. Easysoft supports all SQL data types from the version of SQL Server from version 7. Oracle supports data types that are common to most ODBC Drivers, but not some of the SQL Server ones. If you intend to access VARCHAR(MAX) for example, then there are some additional settings that need to be set up. Now as I would like to show you VARCHAR(MAX) data moving from SQL Server to Oracle, I have made the relevant change. As you can see, VarMaxAsLong says "Yes" We now need to create a link from Oracles Database Gateway (DG4ODBC) to the ODBC datasource that we already have, this is done in an init(sid) oracle file; let's have a look at our file. cat $ORACLE_HOME/hs/admin/initsqlsrv.ora Please note that HS_NLS_NCHAR must be set to UCS2 Oracle assume that most database vendors use UTF-8 for wide characters, however Easysoft, like almost all ODBC Driver vendors (including Oracles own ODBC Driver) uses UCS2 for wide characters. So that's the link between DG4ODBC and the datasource setup correctly. Next we need to set up the Listener entry The Oracle Listener waits for incoming requests from the Oracle database. For the Oracle Listener to listen for requests, information about DG4ODBC must be added to the Oracle Listener configuration file, listener.ora cat $ORACLE_HOME/network/admin/listener.ora The PROGRAM=dg4odbc tells the Listener that we are wanting to use the Oracle database gateway to communicate with ODBC. The ENVS=LD_LIBRARY_PATH tells Oracle what library to load Now that's all set up and OK we need to tell Oracle which server to attach the listener entry to. This is done in tnsnames.ora, and he is the file that we ensured was set up earlier. cat $ORACLE_HOME/network/admin/tnsnames.ora The Oracle Listener now needs to be restarted. lsnrctl stop lsnrctl start OK, that's now started the Listener up again. So we have ensured that all the configuration files are set up correctly. The Listener and tnsnames.ora both set up OK. The final step is to create a link from the Oracle database to the "tnsnames.ora" entry. CREATE PUBLIC DATABASE LINK ODBC CONNECT TO "test" IDENTIFIED BY "test" USING 'sqlsrv_ptr'; Right, that's all done. Let's access the data in SQL Server now. select * from [email protected]c; Where 'demo' is the name of the SQL Server table and 'odbc' is the public database link name. OK, there we have the data. So to recap, I'm in Oracle and we have managed to read the data from SQL Server. Let's just add an additional row in that SQL Server table and retrieve the new data in Oracle. quit; /usr/local/easysoft/unixODBC/bin/isql.sh -v sqlsrv insert into demo values (2,'Easysoft') select * from demo select * from [email protected]; And there is the new data. Easysoft Limited can help you with your data access ... for our full range of ODBC and JDBC Drivers, Bridges and Gateways visit easysoft.com Be sure to let us know if you have any comments or questions. Until next time, thanks again and we'll see you again soon.
Views: 16410 Easysoft Limited
how to create database links
more vedios www.oraman.in
Views: 14295 oramandba
Oracle Networking Between Server and Client machine using TNS listener
Hello friends in today video i am going to explain you that how to perform a Oracle Networking Between Server and Client machine using TNS listener. #OracleNetworking #ServerandClientmachine #TNSlistener Oracle database Unbeatable,Unbreakable Platform..
Views: 13313 Oracle World
Oracle - Database Links
Oracle - Database Links
Views: 22231 Chris Ostrowski
Oracle DB - Synonyms
Oracle DB - Synonyms Watch More Videos at: https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited
How to register listener in database Oracle 11g
How to register listener in database Oracle 11g Base Demo On Listener..
Views: 3308 maddyplus123
Synonyms in Oracle PL SQL
Synonyms in Oracle #techquerypond sql synonyms oracle synonym what is Synonyms in Oracle ? 1)A synonym is an alternative name tO objects. 2)Objects like tables, views, sequences, stored procedures. 3)Generally we use to granting or revoking the access. 4)It means that the synonym is a public synonym and is accessible to all users. 5)Please note user must first have the appropriate privileges to access synonym. To get more information watch the above video. For example: CREATE PUBLIC SYNONYM EMP FOR EMPLOYEE; SELECT * FROM EMP; DROP PUBLIC SYNONYM EMP; https://techquerypond.wordpress.com https://techquerypond.com https://twitter.com/techquerypond
Views: 1385 Tech Query Pond
Identifying Host Names and IP Addresses in SQL and PL/SQL using Built-in Oracle Functionality
This video demonstrates how to do DNS lookups and idenitify server and client host names and IP addresses in SQL and PL/SQL from Oracle. For more information see: https://oracle-base.com/articles/misc/identifying-host-names-and-addresses For information on Network Access Control Lists (ACLs) see: https://oracle-base.com/articles/11g/fine-grained-access-to-network-services-11gr1 https://oracle-base.com/articles/12c/fine-grained-access-to-network-services-enhancements-12cr1 Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Mike Donovan Blog: http://blog.dbvisit.com/author/miked/ Twitter: https://twitter.com/dbvisitmike Website: http://www.dbvisit.com/ Cameo appearances are for fun, not an endorsement of the content of this video.
Views: 8145 ORACLE-BASE.com
Connect to Remote Oracle database using Oracle Sql Developer on Windows.
Three methods of connection to oracle database using sql developer in Windows Operating System, is demonstrated in this online video. 1. Connect using general settings with database service name. 2. Connect by importing xml configuration file. 3. Connect using connection string with jdbc thin client. Oracle SQL Developer download link : http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
Views: 19152 Subhroneel Ganguly
Oracle Database Express Edition (XE) Kullanıcı Oluşturma ve Toad'a Bağlama
Views: 151 Values
9 Oracle Networking in Oracle DBA
Oracle Networking in Oracle DBA
Views: 4035 NewTechnology
Creating JDeveloper Database Connections
Learn how to create database connections using jDeveloper in this free video tutorial from http://www.fireboxtraining.com. We use jDeveloper in our Introduction to Java Training Class. https://www.fireboxtraining.com/java-programming-training. Discover more about learning programming for business at https://www.fireboxtraining.com/
Views: 15779 Firebox Training
Tutorials#76  How to create  SYNONYM in Oracle SQL Database
Explaining How to create Synonym in Oracle SQL Database or what is a synonym in SQL or synonym in SQL Server A synonym is an alternative name for objects such as tables, views, sequences, stored procedures, and other database objects. Assignment: Assignment link will be available soon: In this series we cover the following topics: SQL basics, create table oracle, SQL functions, SQL queries, SQL server, SQL developer installation, Oracle database installation, SQL Statement, OCA, Data Types, Types of data types, SQL Logical Operator, SQL Function,Join- Inner Join, Outer join, right outer join, left outer join, full outer join, self-join, cross join, View, SubQuery, Set Operator. follow me on: Facebook Page: https://www.facebook.com/LrnWthr-319371861902642/?ref=bookmarks Contacts Email: [email protected] Instagram: https://www.instagram.com/equalconnect/ Twitter: https://twitter.com/LrnWthR #equalConnectCoach #rakeshmalviya
Views: 79 EqualConnect Coach
Oracle Database11g tutorials 14 : How to CREATE TABLE using sql developer and command prompt
Oracle Database11g tutorials 14 How to Create table using command prompt and Create table using sql developer Blog Link http://bit.ly/1TkY4Oe Time Line 0:25 Introduction of Tables in Database 1:03 What is Create Table (Introduction of create table) 1:30 Syntax of Create Table 2:08 How to create table using Command Prompt 4:55 How to create table using SQL Developer Links for Oracle Database tutorials 4: database connectivity using SQL developer and command prompt http://youtu.be/wSqoXRlXDUU You can have indepth knowledge about SQL create table here http://www.rebellionrider.com/sql-create-table.html Tool used in this tutorial is command prompt. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. http://in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com Today in this oracle database tutorial we will see How to CREATE A TABLE. if we have to define a table in layman language then we can say that Tables are just a collection of Rows and Columns but In RDBMS tables are database objects which help in organizing data into ROWS and COLUMNS. We can also say that SQL tables are kind of data structure which are used by database for efficient storage of data. To create a table in our database we use SQL CREATE TABLE command. SQL CREATE TABLE is a type of DATA DEFINITION LANGUAGE also known as DDL. To Create a table in your schema you will require CREATE TABLE system privilege. In our future videos we will see what are system and object privileges and how to grant them to a user. Today for this video we will be using Sample schema HR which already has all the necessary privileges. Ohk Let's see the syntax. CREATE TABLE table name ( column name1 Data-Type(size), column name2 Data-Type(size), ..... ); CREATE TABLE is an oracle reserved word or say an Oracle key word whereas There are 3 different ways of creating a table in Oracle database. Creating a table using Command Line Interface (CLI) in Oracle database For demonstrating how to create table in oracle database using CLI, I'll be using Command prompt. Thats how we create table using command prompt. you can check your table structure by DESCRIBE command for that just write DESC and your table name. Like this Another way of creating a table is by using Graphic user interface (GUI) in Oracle database To demonstrate how to create table using GUI we will use SQL developer. Lets open our SQL developer I am connected to HR schema if you do not know how to create a connection to database using SQL developer please watch my oracle database tutorial 4 that explains database connectivity using SQL developer and command prompt. Link for this video is in the description below. So lets create a table. Creating a table using SQL developer is very easy we do not have to fire any query here. Let's start First of all right click on your connection in which you want to create a table and choose schema browser. This will open a separate schema browser pane or you can expend your connection by clicking this + sign and then right click on table and choose New Table. However I prefer working with schema browser so let's skip to schema browser pane here from the first drop-down list you can choose connection name and in the second drop down list you can choose what database objects you want to work with we want to create a table thus I'll choose table and then click this arrow here and choose option for new table Ok we have created a table wizard first of all give a unique name to your table and add some column as well. For this, click the green plus button. Now we already have a column so give it some name. Also choose a datatype from the list and specify any size you can check this not null column if in case you want to make this a mandatory column you can also specify default value and constraint If you want to make this column a primary key you can click here In my future video i'll show you what are these constraints and different ways of applying them on a column in a table. for this video we will concentrate on create table only so when you are done with all your columns click ok Thats your table You can double click on your table here and can see its structure. Thats it
Views: 179928 Manish Sharma
R tutorial: connecting to a database
Learn more about connecting to databases with R: https://www.datacamp.com/courses/importing-data-in-r-part-2 Welcome to part two of importing data in R! The previous course dealt with accessing data stored in flat files or excel files. In a professional setting, you'll also encounter data stored in relational databases. In this video, I'll briefly talk about what a relational database is and then I'll explain how you can connect to it. In the next video, I'll explain how you can import data from it! So, what's a relational database? There's no better way to show this than with an example. Take this database, called company. It contains three tables, employees, products and sales. Like a flat file, information is displayed in a table format. The employees table has 5 records and three fields, namely id, name and started_at. The id here serves as a unique key for each row or record. Next, the products table contains the details on four products. We're dealing with data from a telecom company that's selling both with and without a contract. Also here, each product has an identifier. Finally, there's the sales table. It lists what products were sold by who, when and for what price. Notice here that the ids in employee_id and product_id correspond to the ids that you can find in the employees and products table respectively. The third sale for example, was done by the employee with id 6, so Julie. She sold the product with id 9, so the Biz Unlimited contract. These relations make this database very powerful. You only store all necessary information once in nicely separated tables, but can connect the dots between different records to model what's happening. How the data in a relational database is stored and shuffled around when you make adaptations, depends on the so-called database management system, or DBMS you're using. Open-source implementations such as MySQL, postgreSQL and SQLite are very popular, but there are also proprietary implementations such as Oracle Database and Microsoft SQL server. Practically all of these implementations use SQL, or sequel, as the language for querying and maintaining the database. SQL stands for Structured Query Language. Depending on the type of database you want to connect to, you'll have to use different packages. Suppose the company database I introduced before is a MySQL database. This means you'll need the RMySQL package. For postgreSQL you'll need RpostgreSQL, for Oracle, you'll use ROracle and so on. How you interact with the database, so which R functions you use to access and manipulate the database, is specified in another R package called DBI. In more technical terms, DBI is an interface, and RMySQL is the implementation. Let's install the RMySQL package, which automatically installs the DBI package as well. Loading only the DBI package will be enough to get started. The first step is creating a connection to the remote MySQL database. You do this with dbConnect(), as follows. The first argument specifies the driver that you will use to connect to the MySQL database. It sure looks a bit strange, but the MySQL() function from the RMySQL package simply constructs a driver for us that dbConnect can use. Next, you have to specify the database name, where the database is hosted, through which port you want to connect, and finally the credentials to authenticate yourself. This is an actual database that we're hosting, so you can try these commands yourself! The result of the dbConnect call, con, is a DBI connection object. You'll need to pass this object to whatever function you're using to interact with the database. Before we do that, let's get familiar with this connection object in the exercises!
Views: 42885 DataCamp
12   Oracle networking
Views: 58 Khadeer Khan
How to installation  Oracle Designer 10 g  and Introduction
دي الصلاحيات المطلوبه لليوزر GRANT EXECUTE ON DBMS_LOCK TO &U; GRANT EXECUTE ON DBMS_PIPE TO &U; GRANT EXECUTE ON DBMS_RLS TO &U; GRANT SELECT ON dba_rollback_segs TO &U; GRANT SELECT ON dba_segments TO &U; GRANT SELECT ON sys.v_$nls_parameters TO &U WITH GRANT OPTION; GRANT SELECT on V_$PARAMETER TO &U; GRANT ALTER SESSION TO &U; GRANT CREATE ANY SYNONYM TO &U; GRANT CREATE SESSION TO &U; GRANT CREATE DATABASE LINK TO &U; GRANT CREATE PROCEDURE TO &U; GRANT CREATE ROLE TO &U; GRANT CREATE SEQUENCE TO &U; GRANT CREATE SESSION TO &U; GRANT CREATE TABLE TO &U; GRANT CREATE TRIGGER TO &U; GRANT CREATE TYPE TO &U; GRANT CREATE VIEW TO &U; GRANT DROP ANY SYNONYM TO &U; GRANT SELECT ANY SEQUENCE TO &U; GRANT CREATE PUBLIC SYNONYM TO &U; grant execute on dbms_lock to &U; grant execute on dbms_pipe to a&U; grant execute on dbms_rls to &U; grant select on dba_rollback_segs to &U; grant select on dba_segments to &u; grant select on v_$nls_parameters to &u; grant select on v_$parameter to &u;
Views: 3774 Ahmed Tartour
Listener Basics For DBA
Oracle Listener Basics for Oracle DBA
Views: 30550 Satish Lodam
Connect SQL Developer to Oracle Database Cloud Service
Learn how to connect to Oracle Database Cloud Service using Oracle SQL Developer ================================= 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.
Oracle DBA Tutorial || online training||Networking by Shiva
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://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
How to Connect Tableau with Oracle Database
This video shows how you can connect Tableau with Oracle Database
Views: 8787 Raihan Shafique
Amazon AWS RDS | How to create and connect RDS Database Instance | Part 1
How to launch create Amazon MySQL RDS Instance How to connect to Amazon RDS Instance How to terminate Amazon RDS Instance How to backup Amazon RDS Instance How to launch Amazon RDS Instance
Views: 102414 AWS Like a PRO!
Load sample data model into APEX 18.1 using Quick SQL - [Video 02 - English]
Oracle Application Express: https://apex.oracle.com/en/learn/getting-started/ Quick SQL: https://apex.oracle.com/en/quicksql/ My Blog: (Spanish): http://descubriendooracle.blogspot.com/ Website: http://clartechsolutions.com/ Academy: https://clartechacademy.com/ LinkedIn: https://www.linkedin.com/in/cjmamanorfali/ Twitter: @Clari707
Create RDS instance and Connect  from EC2
More Tutorials = https://goo.gl/hsM1Yx
Views: 20992 Learn IT
Oracle DBA 11g Tutorial in Bangla: Lesson#6 Configuring the Oracle Network Environment
This is Programming language channel. this channel name is leen's teach.
Views: 133 Leen's Tech
APEX Connect 2018 - Connor Mc Donald on the Newest SQL and PLSQL Features
Connor Mc Donald, member of the Developer Advocate Team at Oracle, who took the trip from Australia to Germany to be at APEX Connect 2018, presents the latest SQL and PL/SQL functionalities in Oracle 12c Release 2 and 18c in his keynote. On more than 300 slides, he manages to convey especially the less known features in an extremely entertaining way. APEX Connect 2019 The next APEX Connect will take place in Bonn at the Kameha Grand Hotel from May 7 to 9, 2019. Subscribe to our newsletter and we will inform you about Call for Papers and registration start: http://mydoag.doag.org/inc/newsletteranmeldung.php?id=56 Further links: Presentations of the event for download: https://docs.doag.org/2018/apexConnect/PraesentationenApex2018.zip More APEX videos on the DOAG YouTube channel of APEX Connect 2018 and on [email protected]: https://www.youtube.com/playlist?list=PLdNW-4qOTC3QimGAWPdAKY5-bxzDnkDWU https://www.youtube.com/playlist?list=PLdNW-4qOTC3SmVktxGu4U-wb_nMjgD3P3
Views: 414 doagtv
Amazon AWS RDS | How to create and connect RDS Database Instance | Part 2
How to launch create Amazon MySQL RDS Instance How to connect to Amazon RDS Instance How to terminate Amazon RDS Instance How to backup Amazon RDS Instance How to launch Amazon RDS Instance Amazon RDS Free Tier Instance Launch
Views: 92497 AWS Like a PRO!
[Cơ Sở Dữ Liệu Phân Tán] - [BT Lớn 1] - Chi Nhánh 1
Đề Bài: Công ty Trách nhiệm hữu hạn Thương mại Kim Đức có trụ sở chính đặt tại Khu Công nghiệp Tân Tạo, quận Bình Tân, Thành phố Hồ Chí Minh. Hiện nay, ngoài trụ sở chính, công ty có thêm 3 chi nhánh khác với 3 kho hàng đặt tại Cần Thơ, Đà Nẵng và Hải Phòng. Tại mỗi chi nhánh có hai nhóm người dùng được phép truy cập vào hệ thống cơ sở dữ liệu như sau: nhóm người dùng thủ kho được phép truy cập vào bảng kho hàng của chi nhánh đó, nhóm người dùng trưởng chi nhánh được phép truy cập vào bảng kho hàng và bảng nhân viên của chi nhánh đó. Tại trụ sở chính, ngoài việc là một chi nhánh của công ty (có các hoạt động như những chi nhánh khác), còn có nhóm người dùng giám đốc quản lý tất cả các hoạt động của công ty, nhóm người dùng này được quyền truy cập vào tất cả các bảng trong cơ sở dữ liệu ở tất cả các chi nhánh. Yêu cầu: 1. Sử dụng hệ quản trị CSDL Oracle, cài đặt trụ sở chính và (ít nhất) một chi nhánh khác của công ty Kim Đức. Trong đó quan hệ CHINHANH có mặt tại toàn bộ các chi nhánh, quan hệ NHANVIEN và KHOHANG được phân tán phù hợp với điều kiện truy cập của từng chi nhánh. 2. Cài đặt các nhóm người dùng với các quyền truy cập như đã mô tả.. --Scripts-- Create user CN01 identified by CN01; grant all PRIVILEGES to CN01; ---- Create Table-- create table NHANVIEN( MANV varchar2(50) primary key, HOTEN varchar2(50), NGAYSINH date, GIOITINH varchar2(5), CMND varchar2(20), CHUCVU varchar2(20), MACN varchar2(50), NGAYVAOLAM date, BACTOTNGHIEP varchar2(10) ); create table CHINHANH( MACN varchar2(50) primary key, TENCHINHANH varchar2(50), DIACHI varchar2(100) ); create table KHOHANG( MAHH varchar2(50) primary key, TENHH varchar2(50), SOLUONG int, DVT varchar(5), NGAYSX date, NGAYNHAPKHO date, MACN varchar2(50) ); -----------INSERT DATA------------ ALTER TABLE NHANVIEN ADD CONSTRAINT FK_NV_CN FOREIGN KEY (MACN) REFERENCES CHINHANH(MACN); ALTER TABLE KHOHANG ADD CONSTRAINT FK_KH_CN FOREIGN KEY (MACN) REFERENCES CHINHANH(MACN); INSERT INTO CHINHANH VALUES('CN01','Tr? S? Chính TPHCM','Thành Ph? H? Chí Minh'); INSERT INTO CHINHANH VALUES('CN02','C?n Th?','Qu?n Ninh Ki?u, TP C?n Th?'); INSERT INTO CHINHANH VALUES('CN03','?à N?ng','Qu?n Liên Chi?u, TP ?à N?ng'); INSERT INTO CHINHANH VALUES('CN04','H?i Phòng','Qu?n Lê Chân, TP H?i Phòng'); INSERT INTO NHANVIEN VALUES('NV001', 'Phan Thi Guong', TO_DATE('24/06/1980', 'dd/mm/yyyy'),'Nu', '272089765', 'Giam Doc', 'CN01', TO_DATE('01/02/2005','dd/mm/yyyy'),'Thac Si'); INSERT INTO NHANVIEN VALUES('NV002', 'Pham Ngoc Hung', TO_DATE('31/03/1985', 'dd/mm/yyyy'),'Nam', '236593749', 'Truong Chi Nhanh', 'CN01', TO_DATE('01/02/2005','dd/mm/yyyy'),'Dai Hoc'); INSERT INTO NHANVIEN VALUES('NV006', 'Nguyen Thi Phuong', TO_DATE('11/11/1989', 'dd/mm/yyyy'),'Nu', '215364500', 'Thu Kho', 'CN01', TO_DATE('01/04/2005','dd/mm/yyyy'),'Cao Dang'); INSERT INTO NHANVIEN VALUES('NV010', 'Do Trung Kien', TO_DATE('18/02/1986', 'dd/mm/yyyy'),'Nam', '251638005', 'Ke Toan', 'CN01', TO_DATE('01/07/2007','dd/mm/yyyy'),'Dai Hoc'); INSERT INTO KHOHANG VALUES('HH005', 'Binh Loc Nuoc', 20, 'Bo', TO_DATE('16/03/2006', 'dd/mm/yyyy'), TO_DATE('18/03/2006','dd/mm/yyyy'), 'CN01'); INSERT INTO KHOHANG VALUES('HH006', 'Phu Kien Voi', 50, 'Cai', TO_DATE('09/01/2006', 'dd/mm/yyyy'), TO_DATE('11/01/2006','dd/mm/yyyy'), 'CN01'); SELECT * from KHOHANG; ---- Create role for THUKHO Create role role_THUKHO not identified; grant connect to role_THUKHO; grant select on KHOHANG to role_THUKHO; ----- Create and grant role for user THUKHO Create user THUKHO identified by THUKHO; Grant role_THUKHO to THUKHO; -----Create role for TRUONGCN Create role role_TRUONGCN not identified; Grant connect to role_TRUONGCN; Grant select on KHOHANG to role_TRUONGCN; Grant select on NHANVIEN to role_TRUONGCN; ----- Create and grant role for user TRUONGCN Create user TRUONGCN identified by TRUONGCN; Grant role_TRUONGCN to TRUONGCN; ----Create role for GIAMDOC Create role role_GIAMDOC not identified; Grant connect to role_GIAMDOC; Grant select on NHANVIEN to role_GIAMDOC; Grant select on KHOHANG to role_GIAMDOC; Grant select on CHINHANH to role_GIAMDOC; ---- Create and grant rolo for user GIAMDOC Create user GIAMDOC identified by GIAMDOC; Grant role_GIAMDOC to GIAMDOC; ---- Create DB LINK CREATE PUBLIC DATABASE LINK DBL_CN03 CONNECT TO GIAMDOC IDENTIFIED BY GIAMDOC USING 'CN03'; CREATE PUBLIC DATABASE LINK DBL_CN02 CONNECT TO GIAMDOC IDENTIFIED BY GIAMDOC USING 'CN02'; drop public database link DBL_CN02; ---check DBlink select db_link from user_db_links; ---check data; select * from [email protected]_CN02; select * from [email protected]_CN02; select * from [email protected]_CN02;
Views: 477 Huy Vũ
Citus vs. Single-Node Postgres Database | A Side-by-Side Comparison
In this demo of the Citus database, engineer Marco Slot shines a light on the performance of the Citus extension to PostgreSQL, and the benefits of scaling out Postgres horizontally. Citus is available as open source, as a fully-managed database as a service, and as enterprise software that can be run anywhere. Today Citus is often used by SaaS teams building multi-tenant applications, as well as developers building real-time analytics applications that need sub-second response times across billions of records. Marco showed the original version of this demo in a keynote at PostgresOpen Silicon Valley. People found it so useful that we decided to retool it and share more broadly. The Citus database cluster that Marco creates to compare against a regular Postgres node is a 4-node Citus database cluster with 244GB total RAM and 32 vCPUs, hosted in Citus Cloud (that’s our managed database as a service.) You can learn more about how Citus transforms Postgres into a distributed database at: https://www.citusdata.com/product Read stories about how other enterprises and SaaS businesses are using Citus to scale out Postgres today, in some pretty impressive use cases: https://www.citusdata.com/customers/ Join the Citus database community’s public slack channel: https://slack.citusdata.com/ Star the GitHub repo for the open source Citus database: https://github.com/citusdata/citus
Views: 5205 Citus Data
SQL Consulting | Connect SQL Developer to Oracle Database
Connect SQL Developer to Oracle Database Tutorial http://www.ReportingGuru.com Email us at [email protected] if you need help, custom reports, or reporting architecture setup. Our phone number is 1-(800) 921-4759. Reporting Guru is a US based development company with all resources located in the US. We have many senior level developers with over a decade of development experience. Please let us know if you would like to discuss your requirements or issues free of charge. Our process is taking your requirements and suggesting the best architecture or approach without trying to sell you any specific software. We work as needed and only charge for the hours we work. We do not charge a retainer and there is no minimum charge. We offer the following services: Custom Report Writing | Consulting | Database Development & Integration. Some of our specialties are: --SQL Server Reporting Services SSRS / SQL Server / SQL Server Integration --Services SSIS / SQL Server Analysis Services SSAS --Custom Application Development / Maintenance --Oracle --MySQL --Crystal Reports / Business Objects --BIRT --.NET Development --PHP Development --SharePoint --Microsoft Dynamics --Access --Excel and Pivot Tables --More! CUSTOM REPORT WRITING Our experienced data report writers take your report & business requirements to build the custom reports you need. We deliver reports on demand or on a timed schedule. CONSULTING When your data and reporting team needs guidance or whether you need to build new reports, convert reports, enhance existing reports or need advice on finding the right reporting solution for your business ReportingGuru is here to help. DATABASE DEVELOPMENT & INTEGRATION We create and develop the necessary structure to house business data in a clear and easily accessible manner, so you have the tools to pull the reports you need easily. CUSTOM SOFTWARE & APPS We also offer custom applications for our clients like our Dashboard Guru and Quickbooks Enterprise Connector http://www.reportingguru.com/products/. Reporting Guru's dashboarding software will give interactivity to static web based reports. Our Quickbooks Connector will pull data from Quickbooks into a database for custom reporting purposes. Connect SQL Developer to Oracle Database http://www.ReportingGuru.com Email us at [email protected] or call 1-(800) 921-4759.
Views: 100150 Reporting Guru
طريقة تصطيب الديزاينر وعمل مشروع مصغر عليه
دي الصلاحيات المطلوبه لليوزر GRANT EXECUTE ON DBMS_LOCK TO &U; GRANT EXECUTE ON DBMS_PIPE TO &U; GRANT EXECUTE ON DBMS_RLS TO &U; GRANT SELECT ON dba_rollback_segs TO &U; GRANT SELECT ON dba_segments TO &U; GRANT SELECT ON sys.v_$nls_parameters TO &U WITH GRANT OPTION; GRANT SELECT on V_$PARAMETER TO &U; GRANT ALTER SESSION TO &U; GRANT CREATE ANY SYNONYM TO &U; GRANT CREATE SESSION TO &U; GRANT CREATE DATABASE LINK TO &U; GRANT CREATE PROCEDURE TO &U; GRANT CREATE ROLE TO &U; GRANT CREATE SEQUENCE TO &U; GRANT CREATE SESSION TO &U; GRANT CREATE TABLE TO &U; GRANT CREATE TRIGGER TO &U; GRANT CREATE TYPE TO &U; GRANT CREATE VIEW TO &U; GRANT DROP ANY SYNONYM TO &U; GRANT SELECT ANY SEQUENCE TO &U; GRANT CREATE PUBLIC SYNONYM TO &U; grant execute on dbms_lock to &U; grant execute on dbms_pipe to a&U; grant execute on dbms_rls to &U; grant select on dba_rollback_segs to &U; grant select on dba_segments to &u; grant select on v_$nls_parameters to &u; grant select on v_$parameter to &u; تم شرح طريقه التصطيب للديزانير وعمل مشورغ مصغر وكيفيه تصدير الى الداتا بيز
Views: 1211 Ahmed Tartour
Oracle & Java Prg1 - How to Connect Oracle database with Java using Netbeans IDE
This video explains you how to create a new database connection in java with Oracle database...!
Views: 95579 Thamizharasan Mohan
how to do networking in oracle database
for more vedios :www.oraman.in
Views: 1895 oramandba
How to Change Schema of an Object in SQL Server Database-SQL Server / T-SQL Tutorial Part 28
SQL Server / TSQL Tutorial How to Change Schema of an Object(Table,View,Stored Procedure) in SQL Server Database Link for script used in the video http://www.techbrothersit.com/2016/02/how-to-change-schema-of.html Scenario: You are working as SQL Server developer in Life Insurance Company. They have Database Name TechBrothersIT and one of the Schema name the objects are using is TB. They have given you assignment to Rename the Schema to LIFE.How would you do that? Solution: There is no straight forward way to rename a schema in SQL Server Database. We have to follow below steps to make this change. Step 1: Create a New Schema Step 2: Transfer the Objects to New Schema. Check out our website for Different SQL Server, MSBI tutorials and interview questions such as SQL Server Reporting Services(SSRS) Tutorial SQL Server Integration Services(SSIS) Tutorial SQL Server DBA Tutorial SQL Server / TSQL Tutorial ( Beginner to Advance) http://www.techbrothersit.com/
Views: 8049 TechBrothersIT
Real 1Z0-062 Dumps: Oracle Database 12c Installation and Administration
Sale Oracle https://www.pass4itsure.com/1Z0-062.html Dumps Online Exam, Real Oracle 1Z0-062 Dumps Study Material With Low Price, Pass Oracle Database 12c: Installation and Administration from google drive: https://drive.google.com/open?id=0BwxjZr-ZDwwWNEhYUW1ZWWNVM0U QUESTION 1 A user establishes a connection to a database instance by using an Oracle Net connection. You want to ensure the following: 1.The user account must be locked after five unsuccessful login attempts. 2.Data read per session must be limited for the user. 3- The user cannot have more than three simultaneous sessions. 4. The user must have a maximum of 10 minutes session idle time before being logged off automatically. How would you accomplish this? A.by granting a secure application role to the user B.by implementing Database Resource Manager C.by using Oracle Label Security options D.by assigning a profile to the user Correct Answer: D Explanation Explanation/Reference: QUESTION 2 As a user of the ORCL database, you establish a database link to the remote HQ database such that all users in the ORCL database may access tables only from the SCOTT schema in the HQ database. SCOTT's password is TIGER. The service mane "HQ" is used to connect to the remote HQ database. Which command would you execute to create the database link? A.CREATE DATABASE LINK HQ USING 'HQ'; B.CREATE DATABASE LINK HQ CONNECT TO CXJRRENT_USER USING HQ' S C.CREATE PUBLIC DATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger USING 'HQ'; D.CREATE DATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger USING 'HQ'; Correct Answer: D Explanation Explanation/Reference: Read More Youtube:https://youtu.be/uQAwepycwIM
Views: 28 Exam Videos
Database connection in Eclipse (Oracle) : javavids
How to connect Oracle database in Eclipse? Part of Java online video tutorials: http://www.javavids.com
Views: 91670 Jiri Pinkas
Consumir Web Services en Oracle Apex en Español
Bienvenido, en este espacio encontrarás tutoriales e información sobre Oracle Apex en Español Visita mi blog: http://apex-developers.com/
Stephen Frost: Using Postgres FDW with a sharded PostgreSQL Database
This video will discuss how to set up and use the Postgres FDW with a 32-way sharded PostgreSQL database and go over pros, cons, and limitations. We will talk about how you can use the Postgres FDW to bring all those shards back together- where it works and where it doesn't, and discuss the possible future for the Postgres FDW and how it might be changed to work better.
Views: 1984 Postgres Open SV 2018
02 - ORA-01017 Invalid Username Password
oracle error ORA-01017 : invalid username/password; logon denied A - Cause : public username is invalid B- steps : 1-login to sql as follows 2-connect system as sysdba 3-when password asked enter system {password will not shown while typing} 4-you are connected successfully 5- check correct pubuser running on oracle by the follwoing select username from dba_users; 6-usually you should find it as pubuser or PUBPRM$PM 7- change the public passwrod as follwos: alter user PUBUSER identified by pubuser ; where PUBUSER=public user username and pubuser=public user password
Views: 43099 adel mohd
Linked Server in SQL Server 2012 to Another SQL Server and Excel File
Creating a Linked Server in SQL Server 2012 to Another SQL Server and Excel File. To Learn or Teach Linux visit www.theskillpedia.com, A Marketplace for Learners and Trainers. To know about me visit my profile at www.rnsangwan.com. I deliver online training on Business Analysis, Linux, Unix, MySQL, Sybase, SQL Server, Perl, Python, R Data Analysis, Scala etc. We can Create a Linked Server in SQL Server 2012 to Any other RDBMS provided we have the appropriate driver. In this video I have demonstrated Link Server creation in SQL Server 2012 to Another SQL Server and Link Server to an Excel File. Once Linked Server is created, you can issue queries in the same manner as if you are issuing them on a local table in a database. The Concept is similar to "Link Database" in Oracle.
Views: 35443 TheSkillPedia