Export/Import Strategies For Backing-Up An Oracle Database

Export/Import Strategies For Backing-Up An Oracle Database

Aastha sharma is Data Analyst and XML Developer, having 4 years of experience EBook Publication.
Aastha Sharma
Latest posts by Aastha Sharma (see all)

Export/Import Exports are “logical” database backups in that they extract logical definitions and data from the database to a file. Export The syntax for Export Command. exp username/passward@connection_name file=file_name.dmp tables= table_name log=log_name.log Example Export the table Command exp hr/hr@xe file=emp.dmp tables=employees log=l1.log Import The syntax for Export Command. Imp username/passward@connection_name file=export_file_name.dmp tables= table_name log=log_name.log Example […]

Continue Reading
Export/Import Strategies For Backing-Up An Oracle Database

Exception Handling In Oracle

Charles Andrew is C# programmer, and a web developer, who loves backend and middleware development and still improving his skills at the front-end arena. He loves what he does, here is a list of what he loves to do: read, write and code.
Charles Andrew
Latest posts by Charles Andrew (see all)

Using Exception Handling we can test the code and avoid it from exiting abruptly. When an exception occurs messages which explain its cause is received. Structure of Exception Handling The General Syntax for coding the exception section DECLARE Declaration section BEGIN Exception section EXCEPTION WHEN ex_name1 THEN -Error handling statements WHEN ex_name2 THEN -Error handling […]

Continue Reading