| Transportable tablespace [message #19871] |
Mon, 15 April 2002 13:35  |
Seth
Messages: 3
Registered: November 2000
|
Junior Member |
|
|
I tried to transport tablespace from one database to another using the command
C:>exp sys/**** as sysdba file=c:sethdbtemp.dmp transport_tablespace=y tablespaces=(users)
Export: Release 8.1.7.0.0 - Production on Mon Apr 15 15:40:03 2002
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Username: sys
Password:
Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
EXP-00044: must be connected 'AS SYSDBA' to do Point-in-time Recovery or Transportable Tablespace import
EXP-00000: Export terminated unsuccessfully
|
|
|
|
| Re: Transportable tablespace [message #19873 is a reply to message #19871] |
Mon, 15 April 2002 14:06  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
the correct syntax to use login as sys is
connect sys/****@connect_string as sysdba
even if ur database is in the local machine, give the host string.!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
