skip to main
|
skip to sidebar
Scribbling Notes
Thursday, January 31, 2008
Generate schema creation script using datapump
expdp system/manager directory=tmp_dir dumpfile=a.dmp content=metadata_only schemas=system
impdp system/manager directory=tmp_dir dumpfile=a.dmp sqlfile=p4.sql
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Popular Posts
impdp
expdp system/managerpopv dumpfile=reporter.dmp directory=tmp schemas=reporter impdp system\acomp directory=tmp dumpfile=opvdb.dmp remap_sch...
ORA-19951: cannot modify control file until DBNEWID is completed
nid system/manager dbname=mtrx22 while running nid on a cloned database I forgot to check the tempfile which resulted into following error ...
rman to restore archivelog from backupset and synch a standby db
To list the backup sets of the archive logs. Where or which sets we have the archive logs. RMAN> list backup of archivelog logseq 5594; B...
oracle 10g database characterset change
ORACLE DB version 10.2.0.3 step 1- run csminst.sql it will create a user to hold csscan result. which the csalter will use to convert step ...
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
After moving the backup directory to a NFS for one 10gR2 db I started getting this error. RMAN-03009: failure of backup command on ORA_DISK_...
ORA-17628: Oracle error 19505 returned by remote Oracle server
precreate the contolfile directory in asm diskgroup then retry the duplicate from active database
copy schema using dbms_datapump
declare hand number; js varchar2(9); -- COMPLETED or STOPPED begin -- and owner in ('BACKUP','GATEKEEPER','REFDATA...
goldengate vip getting connection refused
goldengate bidirectional replication on site A,site B,site C the goldengate vip is configured on site A . but this morning when i came ...
ORA-10980 in trace file while creating materialized view?"
I was getting ORA-10980 in trace files. After granting all the permission still was not able to create the materialized view. but somehow p...
recovery using online redo logs for a norarchivelog database
after the platform services did the san migration somehow one of the datafile became corrupted and while i try to open the database it com...
Blog Archive
►
2013
(24)
►
November
(1)
►
August
(1)
►
July
(2)
►
June
(4)
►
May
(3)
►
April
(2)
►
March
(4)
►
February
(3)
►
January
(4)
►
2012
(1)
►
April
(1)
►
2011
(15)
►
September
(1)
►
May
(3)
►
March
(5)
►
February
(3)
►
January
(3)
►
2010
(14)
►
December
(9)
►
May
(1)
►
April
(2)
►
March
(1)
►
January
(1)
►
2009
(10)
►
December
(3)
►
June
(1)
►
April
(1)
►
March
(4)
►
February
(1)
▼
2008
(14)
►
December
(1)
►
September
(1)
►
July
(1)
►
June
(1)
►
April
(2)
►
March
(1)
▼
January
(7)
Generate schema creation script using datapump
moving windows o/s into a ubuntu vmware guest o/s
Installing perl in solaris 8
rman online backup with exclude undo tablespace
calculate exp dump size for oracle db
df shows 100% on a empty filesystem
opmnctl hangs while trying to start the grid control
►
2007
(53)
►
December
(15)
►
November
(33)
►
October
(5)
About Me
Prasad N
View my complete profile
No comments:
Post a Comment