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:
Test connessione come sysdba senza password
Oracle...
Script:
Loader
Unix...
Tip:
How remove a file named -r
PLSQL...
Script:
FOR recordset IN (select statment) LOOP
Oracle...
Tip:
RECO
Oracle...
Faq:
Which chars in table and column names?
Shell scripting...
Script:
Array in do while construct
A User Agent, like a web browser, uses HTTP to request a HTML document
Php Funzione mail()
In programming the danger of exploring the small details of coding is that you get obsessed with every line of code you write, thereby greatly reducing productivity.
In general, is not worth obsessing over code. On the other hand you should code with deliberation and intent. Steven Feurstein Oracle Magazine July /August 2004 A User Agent, like a web browser, uses HTTP to request a HTML document
|
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:
Se non viene definite tablespace permanente e temporanea
Anger is creative, depression is useless.
Dyson, Freeman J. Anger is creative, depression is useless.
Dyson, Freeman J.
Oracle...
Info:
Oggetto directory
Oracle...
Citazioni:
Designing an efficient Schema ...
Oracle...
Definizioni:
Schema
Oracle...
Definizioni:
Area PGA
Shell scripting...
Script:
if e else
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 |