Exportando tablas en oracle usando exp – Habitaciones – Rooms – Money –Negocios – Promotional Code – Phone

Sí trabajamos con bases de datos una actividad muy común será la deexportar e importar tablas. Ejemplo, sí queremos realizar algún respaldo o sí estamos desarrollando un proyecto en casa y luego queremos continuar en la universidad o el trabajo, probablemente debamos llevarnos un respaldo de nuestra base de datos para poder seguir trabajando.

Paraexportar tablas lo que haremos será hacer uso delcomandoexp de oracle de la siguiente manera.

Abrimos la consola de windows usaremos el comandocd (change directory) seguido de 2 puntos (..) para subir hasta eldisco C, luego escribiremos:exp NombreDeUsuarioDeLaBaseDeDatos/Contraseña file=NombreDelArchivoDeRespaldoACrear.dmp y con esto haremos un respaldo de todas las tablas dentro de nuestra base de datos, las cuales estarán en un solo archivo con extensión .dmp almacenado en el disco C.

En mi caso, el comando a utilizar sería:exp scott/tiger file=respaldo.dmp y el resultado el siguiente archivo almacenado en la unidad C.

Sí por ejemplo no queremos respaldar toda la base de datos sino solo algunastablas en específico agregaremos el parametro tables=NombreDeLaTabla

Ejemplo:

exp scott/tiger file=respaldo.dmp tables = TAreas, TLibros

Y el resultado sería:

Y El archivo de respaldo nuevamente será almacenado en el disco C.

También te podría interesar:

1. Importando tablas en oracle usando imp
2. 28+ Libros gratis para aprender a programar.
3. Medir el tiempo de ejecución en Java.
4. De sistema decimal a sistema binario en c++ y Java.
5. Curso Online Aprende MySQL sin dolor.

annuity payment what is structured settlement Php programmers for hire colorado auto accident attorney mesothelioma claim Business management software ANNUITY SETTLEMENT MORTGAGE ADVISER Casino reviews How to Donate A Car in California mesothelioma lawsuit Php programmers Structures Annuity Settlement WordPress themes for designers Dwi lawyer benchmark lending Online casino Live casino structured settlement buyer tennessee mesothelioma lawyer Casino Make money online Australia domain yahoo asbestos lawyers structured annuity settlement city college in miami Mobile casino Forensics online course Hard drive Data Recovery Services Donating a Car in Maryland attorney lawyer mesothelioma Donate Cars Illinois workplace accident attorney Online College Course Nunavut Culture Motor replacements Car Insurance Companies Social media strategies Best social media platforms anti spam appliance canada personals yahoo Hard drive data recovery services Met Auto World trade center footage Psd to WordPress Auto Mobile Insurance Quote Adobe illustrator classes sell structured settlement calculator WordPress theme designers workers compensation lawyer los angeles Motor Insurance Quotes NUNAVUT CULTURE Bankruptcy lawyer Psychic for free integrated ehr Online Christmas cards Car Insurance Quotes New social media platforms Social media platforms for business Business finance group motorcycle accident attorney chicago personal injury lawyer sarasota fl Hire php developers DUI lawyer asterisk call center software ONLINE COLLEDGES Criminal lawyer SELL ANNUITY PAYMENT mesotheloma Hire php programmers criminal defense federal lawyer Service business software Social media management Car Donate Car Insurance Quotes Utah Paperport promotional code Donate Your Car for Kids Online Criminal Justice Degree houston motorcycle accident lawyer structured settlement quote Criminal defense lawyer mesothelioma ct alcohol rehab center in florida World Trade Center Footage Hire php developer washington mesothelioma attorney Car Insurance Quotes PA Webex Costs Custom WordPress theme designer Seo companies DONATE YOUR CAR FOR MONEY Computer science classes online mesotheioma Insurance Cheap Domain Registration Hosting Email Bulk Service Car insurance quotes pa Best social media platforms for business Donate Your Car Sacramento CAR INSURANCE QUOTES PA accident car florida lawyer Futuristic architecture mesothelioma attorneys california Seo company domains yahoo Donating Used Cars to Charity STRUCTURED ANNUITY SETTLEMENT mesothelioma litigation Seo services Best Seo company buying structured settlements ashely madis buyer of structured settlement annuity How to donate a car in California Custom Christmas cards cloud identity and access management cheaper insurance companies donate car for tax credit DONATE CARS ILLINOIS selling annuity mesothelioma lawyer virginia DONATE CARS IN MA Photo Christmas cards WordPress hosting Personal Injury Lawyer Social media examiner Html email Donate Car for Tax Credit Car Insurance Quotes Colorado Dedicated Hosting Dedicated Server Hosting car insurance quotes Donate your Car for Money PAPERPORT PROMOTIONAL CODE purchase structured settlements Data Recovery Raid Tech school Royalty Free Images Stock world trade center footage Social media campaigns personal injury firm HOLLAND MICHIGAN COLLEGE Social media platforms Christmas cards Forex Trading Platform mesothelioma lawyers san diego automobile accident attorney Mesothelioma Law Firm Car Insurance Quotes MN Dayton Freight Lines Donate Car To Charity CALIFORNIA Proud Italian cook Psd to html Italian cooking school mesothelioma mesothelioma charities auto accident attorney life insurance quotes Learning adobe illustrator Social media tools royalty free images stock PSYCHIC FOR FREE Donate cars in ma Donate Car to Charity California Low Credit Line Credit Cards mesothelioma lawyer california mesothelioma survival rates Donate Cars in MA sell annuity payment best criminal lawyer in arizona DONATE A CAR IN MARYLAND Cheap Car Insurance in Virginia Sell Annuity Payment Asbestos Lawyers mesothelioma settlements Annuity Settlements mesothelioma settlement amounts PhD in counseling education houston mesothelioma attorney donate your car for kids REGISTER FREE DOMAINS Health Records Personal Health Record Donate a Car in Maryland Motor Replacements MASSAGE SCHOOL DALLAS TEXAS new york mesothelioma law firm better conferencing calls car insurance quotes mn sell my structured settlement Home Phone Internet Bundle Criminal Defense Attorneys Florida Best Criminal Lawyers in Arizona Life Insurance Co Lincoln Holland Michigan College phd in counseling education Online Motor Insurance Quotes Online Colleges cash out annuity Auto Accident Attorney Paperport Promotional Code Online Classes emergency response plan ppt Injury Lawyers car accident lawyers west palm beach NEUSON Register free domains Massage School Dallas Texas Psychic for Free Donate Old Cars to Charity personal injury law firm Dallas Mesothelioma Attorneys motorcycle lawyer los angeles car accident lawyers los angeles Cheap Auto Insurance in VA low credit line credit cards best accident attorneys Forensics Online Course california mesothelioma attorney CAR INSURANCE QUOTES MN Low credit line credit cards cheap domain registration hosting PHD on Counseling Education Neuson att call conference quotes car uk homeowner loans Car Insurance in South Dakota bus accident attorney los angeles truck accident attorney los angeles Cheap Car Insurance for Ladies WebEx costs Register Free Domains motorcycle accident lawyer san francisco Better Conference Calls LIFE INSURANCE CO LINCOLN mesothelioma lawsuits Futuristic Architecture Mortgage Adviser CHEAP AUTO INSURANCE IN VA los angeles motorcycle accident lawyer Virtual Data Rooms home phone internet bundle Automobile Accident Attorney saskatchewan auto insurance mesothelioma lawyer texas cheap auto insurance in va Car Accident Lawyers Criminal lawyer Miami fortis health insurance temporary Personal Injury Lawyers hosted predictive dialers