| Export DB [message #74252] |
Thu, 21 October 2004 12:09  |
Naveen
Messages: 75
Registered: June 2001
|
Member |
|
|
I tried exporting data from my local DB ( orcl ) to create a similar new DB ( prod ) using the command :-
C:exp file=prodexp.dmp full=y log=prod.log
then i made 3 folders in the ora_home directory:-
1.pfile
2.udump
3.cdump
then copied the init.ora file from orcl to prod folder and modified the names,contorlfiles etc...
Then using the oradim utility :-
C:oradim -new -sid prod1 intpwd prod1 -logon auto
pfile 'C:oracleora92prodinit.ora'
now i started the new service from services..
The next step as given in the oracle9i installation and administrators manual for windows NT is to connect to SQL*PLUS using :
sqlplus /nolog
then the next command is connect /as sysdba/password
Here comes the problem- the syntax for connect is just connect /as sysdba.
But according to the manual its :=
connect /as sysdba/password
How can i move forward, as i get an error ??
Plz help
|
|
|
|
| Re: Export DB [message #74253 is a reply to message #74252] |
Fri, 22 October 2004 03:21  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
post the complete error message.
bash-2.03$ sqlplus /nolog
SQL*Plus: Release 9.2.0.4.0 - Production on Fri Oct 22 07:23:27 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter value for gname:
> connect / as sysdba
Connected.
> show user
USER is "SYS"
> select name from v$database;
NAME
---------
MUTATION
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
