Oracle Database

79K

Solutions

26K

Contributors

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
3
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
1

Expert Comment

by:Karan Rajpoot
Hello All,

I am installing oracle universal installer in linux operating system,but facing below issue
Checking monitor: must be configured to display at least 256 colors
    >>> Could not execute /usr/bin/xdpyinfo    Failed <<<<
someone please tell me how should i resolve this problem
please let me know how i check that my display as atleast 256 colours
0
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
3

Expert Comment

by:Anand Ghatnatti
I am getting error ORA-29279: SMTP permanent error: 504 auth type not available (#5.5.1) please help. I am using Oracle 11g R1
0
LVL 23

Author Comment

by:Steve Wales
This sort of thing is probably better directed as a separate question rather than a comment on the video (you'll hit a wider audience than just me (or anyone else who has commented on the video).

Most likely candidate in my mind is that your relay server isn't set up to accept incoming relay requests from your database server.  But, again, I'd post this as a separate question with more detail than just the error message you're getting.
0
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
0
This video shows how to recover a database from a user managed backup
0
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
0
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
0
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
0
Via a live example, show how to take different types of Oracle backups using RMAN.
0
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode as well as showing how archive log backups are performed
1
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of demo data.
5
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from them.
0
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
3
LVL 5

Expert Comment

by:magento
Hi Steve,

Thanks for information very useful.
In the sameway can you please create a simple video which runs a procedure and store the output of the procedure in shell script to proceed further.

Thanks in advance.
0
LVL 23

Author Comment

by:Steve Wales
Not quite sure what you're looking for.  You want to call a stored procedure that returns a value and then that value is captured in the shell script instead of the return value from the query as shown in the video ?
0
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
0
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
0
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
1

Expert Comment

by:Sarbjit Gill
Very good!!
0
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
3
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
1
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
0

Oracle Database

79K

Solutions

26K

Contributors

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.