Home » RDBMS Server » Server Utilities » export
export [message #69801] Thu, 07 March 2002 23:43 Go to next message
krishna
Messages: 141
Registered: October 1998
Senior Member
When exporting tables , i'm facing this problem. The transcript is as follows: The username/password is plsql/plsql. britney is the name of the database

C:>exp plsql/plsql

Export: Release 8.1.7.0.0 - Production on Thu Mar 7 09:47:06 2002

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Enter array fetch buffer size: 4096 >

Export file: EXPDAT.DMP >

(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U >

Export grants (yes/no): yes >

Export table data (yes/no): yes >

Compress extents (yes/no): yes >

Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set

About to export specified users ...
User to be exported: (RETURN to quit) > plsql

User to be exported: (RETURN to quit) >

. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user plsql
. exporting object type definitions for user plsql
About to export plsql's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export KRIS's tables via Conventional Path ...
. . exporting table ACCOUNTS

At this point it simply gets stuck. It just doesn't proceed. What could be the problem?
Re: export [message #69808 is a reply to message #69801] Fri, 08 March 2002 05:49 Go to previous messageGo to next message
Grant
Messages: 578
Registered: January 2002
Senior Member
exp system/manager owner=plsql file=plsql.dmp log=plsql.log
Re: export [message #69924 is a reply to message #69801] Tue, 19 March 2002 23:33 Go to previous message
avinash
Messages: 22
Registered: February 2001
Junior Member
No problem! Just close console directly
Your data has been backed up.
Previous Topic: Re: OCP Exam Papers
Next Topic: Re: FREE OCP PAPERS
Goto Forum:
  


Current Time: Fri Apr 19 09:23:01 CDT 2024