| how i recover my old table with data [message #170919] |
Sat, 06 May 2006 04:08  |
mfa786
Messages: 210
Registered: February 2006
Location: karachi
|
Senior Member |
|
|
hi master
Sir last day I was using 9i next day I cam in office but my system not run my network dept. and they copy my all data with oracle9i folder in E drive after copy they format my system and install new oracle9i
now I have previous oracle91 folder with data base my database name fahim
please give me idea how I recover my all data with table,view and orther thing in new oracle9i or which file have all data ,table and all thing
any tool for this problem if yes then please send me link
thanking you
aamir
|
|
|
|
| Re: how i recover my old table with data [message #171036 is a reply to message #170919] |
Mon, 08 May 2006 01:26  |
orausern
Messages: 826
Registered: December 2005
|
Senior Member |
|
|
If all of your datafiles, control files and redo log files are in tact, then you just have to place them back and make a script for creating the database with necessary tablespaces.
otherwise you can do a full import.
|
|
|
|
| yes i have all files [message #171212 is a reply to message #171036] |
Tue, 09 May 2006 01:42 |
mfa786
Messages: 210
Registered: February 2006
Location: karachi
|
Senior Member |
|
|
hi master
sir yes i have all files but how i create script for database
and new database aamir and old database name fahim
thanking you
aamir
|
|
|
|
| Re: yes i have all files [message #171221 is a reply to message #171212] |
Tue, 09 May 2006 01:49 |
orausern
Messages: 826
Registered: December 2005
|
Senior Member |
|
|
See:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/create.htm#1003614
| Quote: |
Step 6: Issue the CREATE DATABASE Statement
To create the new database, use the CREATE DATABASE statement. The following statement creates database mynewdb:
CREATE DATABASE mynewdb
USER SYS IDENTIFIED BY pz6r58
USER SYSTEM IDENTIFIED BY y1tz5p
LOGFILE GROUP 1 ('/vobs/oracle/oradata/mynewdb/redo01.log') SIZE 100M,
GROUP 2 ('/vobs/oracle/oradata/mynewdb/redo02.log') SIZE 100M,
GROUP 3 ('/vobs/oracle/oradata/mynewdb/redo03.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/vobs/oracle/oradata/mynewdb/system01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE tempts1
DATAFILE '/vobs/oracle/oradata/mynewdb/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE '/vobs/oracle/oradata/mynewdb/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;
|
Pl. note that this is just a sample..you will have to modify all file name and paths....
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
