Home| Progetto| Web| Faq| Acronimi | ||||
Argomenti Documenti pubblicabili:1120
Scripts:1282 Documenti non pubblicabili:162 Categorie tematiche:68 .Net |_C# |_Visual basic.net |_Asp.net Active Server Pages C++ Cascade Style Sheet JavaScript Mysql Php Xml Java |_Java 2 Micro Edition |_Java server pages |_Java Servlet Oracle |_PLSQL PostgreSQL Unix
Oracle...
Info:
Ricavare lista oggetti modificati in un dato intervallo di tempo
Oracle...
Script:
Check if database is running on Rac or Exclusive via plsql dbms_utility
Unix...
Tip:
Eseguire più comandi in una sola linea
PLSQL...
Script:
DYN SQL
Oracle...
Tip:
RECO
Oracle...
Faq:
Rename column
Shell scripting...
Script:
Script for archiving and compressing folder and file
Basically, a web session can be defined as the timeframe in which a visitor navigates your web site.
Php Funzione mail()
XPath is a language for addressing parts of an XML document.
It is designed to be used by XSLT and XPointer.
Basically, a web session can be defined as the timeframe in which a visitor navigates your web site.
|
Oracle
Home >Oracle > impdp / expdp importare in sql metadata del database
Obiettivo
Nell'esempio viene utilizzato l'utente unix oracle e lo schema schema SYS del database utilizzando un directory DATA_PUMP_DIR registrata nel database, da notare la sintassi \"/ as sysdba\" che autentifica SYS senza richiedere la password (quandousa autenficazione da OS) alternativamente si può utilizzare qualsiasi schema :
[oracle@server01 log]$
expdp \"/ as sysdba\" FULL=Y CONTENT=METADATA_ONLY dumpfile=full_metadata_CUSTOMER01_20120505_103001
logfile=full_metadata_CUSTOMER01_20120505_103001.log
directory=DATA_PUMP_DIR
EXPDP produce pertanto il file dump: Export: Release 10.2.0.4.0 - 64bit Production on Friday, 06 May, 2011 11:08:30 Copyright (c) 2003, 2007, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options Starting "SYS"."SYS_EXPORT_FULL_01": "/******** AS SYSDBA" FULL=Y CONTENT=METADATA_ONLY directory=DATA_PUMP_DIR dumpfile=full_metadata_CUSTOMER01_20120505_103001 Processing object type DATABASE_EXPORT/TABLESPACE Processing object type DATABASE_EXPORT/PROFILE Processing object type DATABASE_EXPORT/SYS_USER/USER Processing object type DATABASE_EXPORT/SCHEMA/USER Processing object type DATABASE_EXPORT/ROLE Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT Processing object type DATABASE_EXPORT/SCHEMA/ROLE_GRANT Processing object type DATABASE_EXPORT/SCHEMA/DEFAULT_ROLE Processing object type DATABASE_EXPORT/SCHEMA/TABLESPACE_QUOTA Processing object type DATABASE_EXPORT/RESOURCE_COST Con IMPDP importare in un file sql i dump prodotto: con il parametro SQLFILE viene definito la modalità (SQL) e nome del file di destinazione:
[oracle@server01 log]$ impdp \"/ as sysdba\" dumpfile=full_metadata_CUSTOMER01_20120505_103001.dmp SQLFILE=full_metadata_CUSTOMER01_20120505.SQL
logfile=sqlfile_full_metadata_CUSTOMER01_20120505.log
directory=DATA_PUMP_DIR
Infine, verificare il risultato dell'IMPDP:
[oracle@server01 log]$ more full_metadata_CUSTOMER01_20110505.SQL
-- CONNECT SYS -- new object type path is: DATABASE_EXPORT/TABLESPACE CREATE UNDO TABLESPACE "UNDOTBS1" DATAFILE '+DATA_CUSTOMER01/CUSTOMER01/datafile/undotbs1.258.659805275' SIZE 26214400 AUTOEXTEND ON NEXT 5242880 MAXSIZE 32767M BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL AUTOALLOCATE; ALTER DATABASE DATAFILE '+DATA_CUSTOMER01/CUSTOMER01/datafile/undotbs1.258.659805275' RESIZE 397410304; CREATE TABLESPACE "SYSAUX" DATAFILE '+DATA_CUSTOMER01/CUSTOMER01/datafile/sysaux.257.659805275' SIZE 125829120 AUTOEXTEND ON NEXT 10485760 MAXSIZE 32767M LOGGING ONLINE PERMANENT BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; Dott. Marco Magnani dba Telecommunicazioni Ingegneria Warning: include(ads/text468x15.html): failed to open stream: No such file or directory in D:\inetpub\webs\fishscriptcom\documents\view_document.php on line 131 Warning: include(): Failed opening 'ads/text468x15.html' for inclusion (include_path='.;C:\php\pear') in D:\inetpub\webs\fishscriptcom\documents\view_document.php on line 131 Tutorial ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Script ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Comandi ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Codici errore ![]() ![]() ![]() ![]() ![]() |
Cerca
Oracle...
Info:
Test connessione come sysdba senza password
A good scientist is a person with original ideas.
A good engineer is a person who makes a design that works with as few original ideas as possible. There are no prima donnas in engineering. Freeman Dyson A good scientist is a person with original ideas.
A good engineer is a person who makes a design that works with as few original ideas as possible. There are no prima donnas in engineering. Freeman Dyson
Oracle...
Info:
Se non viene definite tablespace permanente e temporanea
Oracle...
Citazioni:
Designing an efficient Schema ...
Oracle...
Definizioni:
Variabile bind
Oracle...
Definizioni:
Scalar Subquery
Shell scripting...
Script:
Formatting text as bold withing shell script
fishScript.Com is accessible by Mobile access technology
as mobile phones, Palm and Pocket PC .
Nicoleta e Marco Magnani tutorial, examples, courses, esempi, corsi, esercizi, appunti vari Dottoressa Nicoleta Dragu Formatrice Docente Insegnante Mediatrice Culturale Dott. Marco Magnani Universita La Sapienza Roma Master Computer Science Hunter College New York , Data Base Administrator DBA oracle System architect |