Skip to main content

You should follow the steps as below mentioned:-

  • Export the user
  • Perform import using the command
    imp system/manager file=export.dmp indexfile=newriteindexfile=newfile.sql
    This will createimport the data and save all definitions into newfile.sql.
  • Drop necessary objects.
  • Run the script newfile.sql after altering the tablespaces.
  • Import from the backup for the necessary objects.

You should follow the steps as below mentioned:-

  • Export the user
  • Perform import using the command
    imp system/manager file=export.dmp indexfile=newrite.sql
    This will create all definitions into newfile.sql.
  • Drop necessary objects.
  • Run the script newfile.sql after altering the tablespaces.
  • Import from the backup for the necessary objects.

You should follow the steps as below mentioned:-

  • Export the user
  • Perform import using the command
    imp system/manager file=export.dmp indexfile=newfile.sql
    This will import the data and save all definitions into newfile.sql.
  • Drop necessary objects.
  • Run the script newfile.sql after altering the tablespaces.
  • Import from the backup for the necessary objects.
deleted 11 characters in body
Source Link
joanolo
  • 13.6k
  • 8
  • 39
  • 66

You should follow the steps as below mentioned:-

-Export the user
– Perform import using the command imp system/manager file=export.dmp      indexfile=newrite.sql. This will create all definitions into newfile.sql.
– Drop necessary objects.
– Run the script newfile.sql after altering the tablespaces.
– Import from the backup for the necessary objects.
  • Export the user
  • Perform import using the command
    imp system/manager file=export.dmp indexfile=newrite.sql
    This will create all definitions into newfile.sql.
  • Drop necessary objects.
  • Run the script newfile.sql after altering the tablespaces.
  • Import from the backup for the necessary objects.

You should follow the steps as below mentioned:-

-Export the user
– Perform import using the command imp system/manager file=export.dmp      indexfile=newrite.sql. This will create all definitions into newfile.sql.
– Drop necessary objects.
– Run the script newfile.sql after altering the tablespaces.
– Import from the backup for the necessary objects.

You should follow the steps as below mentioned:-

  • Export the user
  • Perform import using the command
    imp system/manager file=export.dmp indexfile=newrite.sql
    This will create all definitions into newfile.sql.
  • Drop necessary objects.
  • Run the script newfile.sql after altering the tablespaces.
  • Import from the backup for the necessary objects.
Source Link
Md Wasi
  • 101
  • 1

You should follow the steps as below mentioned:-

-Export the user
– Perform import using the command imp system/manager file=export.dmp      indexfile=newrite.sql. This will create all definitions into newfile.sql.
– Drop necessary objects.
– Run the script newfile.sql after altering the tablespaces.
– Import from the backup for the necessary objects.